There is a need to create a stable backup of your VCSA or restore it properly.
VCSA with Embedded Database:
To backup the VCSA with Veeam, it's important to understand that Veeam does not directly support Postgres SQL (VMware's embedded DB). Instead, it's optimal to perform backup in 2 parts:
- Image Level Backup with Veeam
- Database backup via VMware Best Practice
To backup the VCSA with Veeam (step 1):
- Create a typical backup job
- Enable VMware Tools Quiescence
- Ensure Application-Aware Image Processing (AAIP) is either disabled or excluded for the VCSA VM.
- Customize other settings to desired configuration.
To backup the VCSA Database (step 2):
- See this VMware KB on how to backup the database.
When restoring the VCSA, there are some Considerations and Limitations from VMware. Once you understand the considerations and limitations, it's important to understand how to restore your vCenter when there is no vCenter in which to point Veeam. Then you are ready to perform a Full VM Restore or Instant VM Restore.
Once the VCSA is fully restored, if database backups were created, you are now ready to restore the Embedded Database to the desired point in time using the steps mentioned in the above KB.
VCSA with External DB:
Backup is the same as above with the difference that you may also create an image-level backup of the database server if you so choose. The benefit here is that you may restore the entire VM to a specified state. This state will be of the time in which the image backup was created and without capability of point-in-time database restores.
For Microsoft SQL and Oracle databases, Veeam can perform log backups to provide point-in-time restores.
- For requirements, details, and how to enable log processing for Microsoft SQL, see this KB.
- For requirements, details, and how to enable log processing for Oracle, see this KB.
The restore process is yet the same as the previous steps with these exceptions:
- VCSA requires the database to function. If needed, the database/server should be restored first.
- Once the database is restored you can restore the VCSA via Full VM Restore or Instant VM Restore.