On the same host name, you can restore a vRealize Automation SQL database from a backup with no further steps required. If you restored to a different host name, you take additional steps to revise configuration information.

Procedure

  1. Update the database entries.
    1. In SQL Server Management Studio, locate the following table.

      DynamicOps.RepositoryModel.Models

    2. In the table, locate the Data Source string, and update the SQL Server host name using FQDN format. Update each instance of the connection string.

      Data Source=new-database-server-FQDN;...

  2. On each IaaS Web site host that is not being reinstalled, update the database server host name.
    1. Open the following file in a text editor.

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

    2. Make the following changes.
      • Locate the Data Source, and update the SQL Server host name using FQDN format. Update each instance of the connection string.

        Data Source=new-database-server-FQDN

      • If you also changed the database name, update the Initial Catalog.

        Initial Catalog=new-database-name;

    3. Save and close Web.config.
  3. Open a command prompt as Administrator, and run iisreset.
  4. On each IaaS Manager Service host that is not being reinstalled, update the database server host name.
    1. Open the following file in a text editor.

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

    2. Make the following changes.
      • Locate the Data Source, and update the SQL Server host name using FQDN format. Update each instance of the connection string.

        Data Source=new-database-server-FQDN

      • If you also changed the database name, update the Initial Catalog.

        Initial Catalog=new-database-name;

    3. Save and close ManagerService.exe.config.
  5. Restart the Manager Service.

What to do next