6.2
Table Of Contents
- System Administration
- Contents
- System Administration
- Updated Information
- Configuring vRealize Automation
- Configuring System Settings
- Configuring IaaS
- The Customer Experience Improvement Program
- Configure the vRealize Automation Appliance Database
- Perform an Appliance Database Failover
- Validate Appliance Database Replication
- Bulk Import, Update, or Migrate Virtual Machines
- Managing vRealize Automation
- Managing Tenants
- Brand Tenant Login Pages
- Install a Hotfix
- Updating vRealize Automation Certificates
- Extracting Certificates and Private Keys
- Update vRealize Automation Certificates when all are Expired
- Updating the Identity Appliance Certificate
- Updating the vRealize Appliance Certificate
- Updating the IaaS Certificate
- Replace the Identity Appliance Management Site Certificate
- Updating the vRealize Appliance Management Site Certificate
- Replace a Management Agent Certificate
- Resolve Certificate Revocation Errors
- View License Usage
- Monitoring Logs and Services
- Starting Up and Shutting Down vRealize Automation
- Customize Data Rollover Settings
- Remove an Identity Appliance from a Domain
- Backup and Recovery for vRealize Automation Installations
- Backing Up vRealize Automation
- Activate the Failover IaaS Server
- vRealize Automation System Recovery
n
If one database fails, restore it and revert the functional database to the version that was in use when
the backup used to restore the failed database was created.
The backup time for each database can differ. The greater the gap between the last working time of the
databases, the greater the potential for data loss.
For information about how to restore a PostgreSQL database, see the VMware Knowledge Base article
Migrating from external vPostgres appliance to a vPostgres instance located in the vCAC appliance
(2083562)..
Database Passphrases
IaaS MSSQL database security requires a security passphrase to generate an encryption key that
protects the data. You specify this passphrase when you install vRealize Automation.
If you lose the passphrase, or want to change the passphrase, consult VMware technical support for
more information.
Configure vRealize Automation MSSQL Databases with New Host Names
You can restore an MSSQL database from a backup with no additional steps required. If the hostname of
the MSSQL database machine changes, you must revise configuration information for the MSSQL
database.
Procedure
1 Update the database entries.
a Open SQL Server Management Studio and locate the DynamicOps.RepositoryModel.Models
table.
b 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;...
System Administration
VMware, Inc. 85