Each of the service administration tools, VCC and VSPC, store all of their configuration data in a MSSQL database which makes it the main component to protect.
To do so, there are multiple options such as:
- (VCC-only) Use the built-in configuration backup and restore utility.
- Backup the entire server where the MSSQL Server is running and the database files are stored using Veeam Backup & Replication and/or Veeam Agent for Windows.
- Check the VBR best practices guide for more info.
Backup only the database using MSSQL maintenance plans.
Do not forget to store them on a secure location or use a File Copy Job to copy them off to a Veeam Backup Repository.
The result is a SQL backup (BAK) stored on the filesystem:
With these backups, administrators can restore the entire application server or just the database:
- (VCC-only) Use the built-in configuration backup and restore utility to restore the database to the original SQL server or migrate it to a new one.
- Using Veeam Backup & Replication and the Veeam Explorer for MSSQL Server, the following options are available:
Using MSSQL backup files (BAK):
Go to SQL Management Studio and right-click on Databases -> Restore Database.
Browse for the database backup path and click OK to restore.
Once restored, right-click again on the database -> properties and go to the Files page. Check if the database Owner is correct and corresponds to the service account used for the application service.
IMPORTANT: Do not forget to set up a new maintenance plan or check the existing one to keep creating backups of the application database!