The system administrator restores the IaaS MSSQL database and the PostgreSQL database.

There are two scenarios for database recovery.

If both databases fail, restore them from the last known time the databases were both backed up.

If one database fails, restore it and revert the functional database to the version in use at the time the backup you use to restore the failed database was created.

The time of backup for each database does not need to be identical. However, the greater the gap between the last working time of the databases, the greater the potential for data loss.

For information on restoring a PostgreSQL database, see the VMware Knowledge Base article Migrating from external vPostgres appliance to a vPostgres instance located in the vCAC appliance (2083562) at http://kb.vmware.com/kb/2083562.

You can restore an MSSQL database from a backup and no additional steps are required. However, if the hostname of the machine that hosts MSSQL database is changed, you must revise configuration information for the MSSQL database as described in the following procedure.

1

Update the database entries.

a

Open SQL Server Management Studio.

b

Locate the DynamicOps.RepositoryModel.Models table.

c

Locate the string Data Source in the table and change the original SQL Server host name to the new host name for each instance of the connection string.

For example:

Data Source=MACHINE-NAME.domain.name;...
2

For each machine that does not need to be reinstalled and has a Website component installed, edit the configuration file.

a

Open the file C:\Program Files (x86)\VMware\vCAC\Server\Model Manager Web\Web.config in an editor.

b

Locate the repository element and make the following changes:

 C:\Program Files (x86)\VMware\vCAC\Server\Model Manager Web\Web.config 
			 

Modify the value of the server attribute for the database hostname. For example:

server=DB-repository-hostname.domain.name
				  

If you have changed the database name, modify the value of the database attribute to use the new name.

3

Run iisreset from an account with administrator privileges.

4

For each machine that does not need to be reinstalled and has a Manager Service component installed, change the host name in the following configuration file.

C:\Program Files (x86)\VMware\vCAC\Server\ManagerService.exe.config 
			 
a

Locate the string Data Source and change the original SQL Server host name to the new host name for each instance of the connection string. For example:

server=DB-hostname.domain.name
				  
b

If you have changed the database name, modify the value of the Initial Catalog attribute to use the new name. For example:

 Initial Catalog=DBName;
				
5

Restart the Manager Service.

Restore the Identity Appliance. For more information, see Restoring the Identity Appliance.