How to backup a MS SQL database using the Attix5 VSS plug-in

Attix5 Pro makes use of the MS 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:

  • SQL 2005
  • SQL 2008
  • SQL 2012

Installation & Configuration

  1. Ensure the Attix5 Pro software is installed and a backup account has been created.
  2. Download and run the Attix5 Plug-in installer from the Download page.
  3. Follow the plug-in wizard and ensure that the VSS plugin is enabled.
  4. Run the Attix5 Pro software. You will now notice a new entry on the left hand side.

    Attix5 VSS SQL Plugin
  5. When you select and expand the VSS Plug-in you will see the MS SQL Server Group. Right click on this note and select it for inclusion in the backup.
  6. On the right hand side you will also see further options. Select the type of backup you require: Full Backup or Copy Backup and click Apply.
  7. Click on Backup to start the backup process.
Useful Tip

Occasionally the VSS plug-in will not display the SQL Group, or the backup will fail with various errors. Commonly this is due to an existing backup program. Ensure that the old backup software has been uninstalled and restart the server to reset the VSS.

Additionally, check the Windows Event Log for further errors.

SQL Backup Notes

Full Backup

Following a Full Backup, the backup history of each file will be updated and, in the case of Exchange writers, the backup transaction logs will be truncated. 


If employing other backup/archiving processes in addition to Attix5 Pro that require full backup transaction logs (e.g. Exchange tape backup), it is recommended that you use Copy Backup instead, as Copy Backups retain full transaction logs.

Copy Backup

Copy Backups leave the backup history of each file and the application logs as they were before the backup. This is recommended if using additional backup/archiving processes that require full backup transaction logs. 


If both the SQL database and Exchange server are on the same machine, the Full/Copy setting will apply to both.


0 (0)
Article Rating (No Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    There are no comments for this article. Be the first to post a comment.
    Security Code Security Code
    Related Articles RSS Feed
    How to backup MySQL on Attix5 Server Edition for Windows
    Viewed 8474 times since Fri, May 30, 2014
    How to Run a Snapshot Export Backup
    Viewed 3796 times since Sun, Aug 16, 2015
    How to run the Attix5 service as a specific user
    Viewed 5979 times since Fri, May 16, 2014
    Throttle connection upload speed on Attix5 Pro
    Viewed 8058 times since Thu, May 15, 2014
    How to Setup Email Notifications
    Viewed 5690 times since Sat, Aug 15, 2015
    Perform an Attix5 disk Snapshot
    Viewed 8716 times since Fri, Jun 13, 2014
    How to backup an Exchange server using the Attix5 VSS plugin
    Viewed 7114 times since Tue, Nov 4, 2014
    How to restore an Exchange database using the Attix5 VSS plug-in
    Viewed 6404 times since Wed, Nov 5, 2014