How to backup a MS SQL database using BackupVault Pro


BackupVault Pro makes use of the Microsoft Volume ShadowCopy Service (VSS) to back up open files such as an Outlook PST file, which is just a fraction of what VSS can do. The VSS plug-in utilises VSS on a much more advanced level by allowing you to protect any VSS-enabled database and application available on your server with a single plug-in; without the need for a database dump. A perfect example of this is a Microsoft SQL database server.

The Attix5 VSS plugin supports the following versions of Microsoft SQL:

Installation & Configuration

  1. Ensure the BackupVault Pro software is installed and a backup account has been created.
  2. Open the BackupVault Pro software. You will now notice a SQL tab on the left hand side.



  3. Right click on the specific database you need to backup and click on Include.
  4. If you would like to backup all databases, right click on the top SQL tree and click Include.
  5. Click on Backup to start the backup process.

Tip! We recommend that you always backup the entire SQL selection tree to select all databases. Then specifically exclude any databases that you do not need backing up. This way, if a new database is created in the future, it will automatically be selected and backed up.

Tip! If the SQL tab does not appear on the left hand side you need to adjust the SQL permissions.

Restoring MS SQL Databases

If you would like to restore a database, follow the How to restore MS SQL tutorial.



Article ID: 30
Created: Wed, Nov 12, 2014
Last Updated: Sun, Jun 23, 2019
Author: Rob Stevenson

Online URL: https://www.backupvault.co.uk/kb/article/how-to-backup-a-ms-sql-database-using-backupvault-pro.html