The database administrator backs up the Infrastructure MSSQL Server and Appliance Database.

Back up the Infrastructure MSSQL and Appliance Database or legacy PostgreSQL databases as nearly simultaneously as possible to prevent or minimize data loss. Also, when applicable, back up databases with Point-in-Time enabled. By using Point-in-Time recovery, you ensure that the two databases are consistent with each other.
Note: If only one database fails, you must restore the running database to the most recent backup so that the databases are consistent.

Infrastructure MSSQL Database

Back up the Infrastructure MSSQL and Appliance Database or legacy PostgreSQL databases as nearly simultaneously as possible to prevent or minimize data loss. Also, when applicable, back up databases with Point-in-Time enabled. By using Point-in-Time recovery, you ensure that the two databases are consistent with each other. If only one database fails, you must restore the running database to the most recent backup so that the databases are consistent.

Follow your in-house procedures to back up the Infrastructure MSSQL database outside of the VMware Aria Suite framework.

Use the following guidelines when creating a backup:

  • If possible, check that all IaaS workflows are complete and that all IaaS services are stopped or that activity is minimized.
  • Back up with Point-in-Time is enabled.
  • Back up the MSSQL database alongside the back up the other components.
  • Back up the passphrase for your database.
Note: Your database is protected by a passphrase. Have the passphrase available when you restore the database. Usually, you record the passphrase in a safe and accessible location at install time.

Appliance Database or Legacy PostgreSQL Database

If you are using an Appliance Database or a legacy PostgreSQL database embedded in a VMware Aria Automation appliance, you can back up the database by backing up the entire appliance.

If you are using a standalone legacy PostgreSQL appliance, you must back up the appliance.

If you are using a legacy PostgreSQL database, you can also backup the database separately. For more information, see the VMware Knowledge Base article Migrating from external vPostgres appliance to vPostgres instance located in the VMware vRealize Automation appliance (2083562) at http://kb.vmware.com/kb/2083562 for more information.