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. 

Warning

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. 

Warning

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.
    Comments
    There are no comments for this article. Be the first to post a comment.
    Name
    Email
    Security Code Security Code
    Related Articles RSS Feed
    How to restore an Exchange database using the Attix5 VSS plug-in
    Viewed 2798 times since Wed, Nov 5, 2014
    Exchange Backup Frequently Asked Questions
    Viewed 2125 times since Mon, Aug 17, 2015
    How to configure the MS SQL Attix5 Pro Plugin
    Viewed 4355 times since Fri, May 16, 2014
    How to Backup Capita SIMS Using the Attix5 Plugin
    Viewed 1689 times since Tue, Apr 12, 2016
    Perform an Attix5 disk Snapshot
    Viewed 3487 times since Fri, Jun 13, 2014
    How to Restore Windows System State
    Viewed 1990 times since Sun, Aug 16, 2015
    How to Backup Windows System State
    Viewed 1886 times since Sun, Aug 16, 2015
    How to Run a Snapshot Import Restore
    Viewed 1489 times since Sun, Aug 16, 2015
    How to calculate your backup upload speed
    Viewed 3020 times since Fri, Jun 27, 2014
    How to run the Attix5 service as a specific user
    Viewed 3061 times since Fri, May 16, 2014