To back up a SQL Server vault database, use the Prepare for Backup Wizard the same as a Hypertrieve vault database as explained in Prepare For Backups. With SQL Server as the database engine, Accruent SQLIO uses the SQL Server backup functions to create the backup files in the vault's Backup folder. You can then back up the files in the Backup folder with standard backup software.
Do not create vault database backups directly with SQL Server Enterprise Manager. The Prepare for Backup Wizard in the Meridian Enterprise Administrator must be used in order to first commit the transaction logs that the EDM Server service generates. These are required for a complete backup.
To restore a backup of a SQL Server vault database, restore the backed up files from the backup media to the Backup folder and then use the Restart After Restore Wizard as described in Restore Backups. This ensures the integrity and compatibility of the database with the host computer.