Understanding SQL Server vault backups

To back up a SQL Server vault database, use the Prepare for Backup Wizard the same as a Hypertrieve vault database as explained in Preparing for backups. With SQL Server as the database engine, BlueCielo 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.

Warning    Do not create vault database backups directly with SQL Server Enterprise Manager. The Prepare for Backup Wizard in 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 Restoring backups. This ensures the integrity and compatibility of the database with the host computer.