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

Once you have followed how to backup a MS SQL database you will be ready to restore it. 


VSS restores can overwrite current live data. During a restore, data is downloaded from the Storage Platform and written to a temporary location on the hard drive. This location is a folder that will temporarily hold the restored data, before it is streamed back into the database from where it was initially backed up.

Therefore, take care when doing test restores as they will overwrite any current data in the database with the data from the restore. Naturally, if you restore only a certain section of data (i.e. one information store), the rest of the database will not be affected.

The only way to avoid this scenario is to restore to a different machine, although some other components like Active Directory may need to be set up first.

  1. Open the Restore tab, expand the VSS Writers node, and then select the SqlServerWriter node.
  2. Include the writer by right-clicking the node, and then selecting Include on the shortcut menu that appears. You can also expand the node and select a specific SQL database.

    Attix5 MS VSS Restore

  3. Click the Restore button in the toolbar. The Restore Options dialog box will appear.
  4. On the General tab, you will note that you cannot restore to the original location when selecting any items from the VSS Database section as VSS will do that once the data is restored. Select a temporary restore location using the Browse button or enter a path to on in the Folder box. Ensure that there is adequate disk space.
  5. Click Restore to start the restore process.

After the data has been restore from the BackupVault Storage Platform it will temporarily be written to disk. The VSS component will then import the data into the live MS SQL server.


If it is not desirable to restore the SQL database directly back into the running MS SQL, it is also possible to restore the individual mdf and ldf files. In the restore tree, expand the database you wish to restore and select the individual files.

These files can then be restored and manually moved back to the database.

Attix5 SQL VSS Restore Files

5 (1)
Article Rating (1 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
    Exchange Backup Frequently Asked Questions
    Viewed 2542 times since Mon, Aug 17, 2015
    How to backup MySQL on Attix5 Server Edition for Windows
    Viewed 5354 times since Fri, May 30, 2014
    How to restore SQL database files with a .DAT extension in Attix5
    Viewed 7487 times since Fri, May 16, 2014
    How to backup an Exchange server using the Attix5 VSS plugin
    Viewed 5367 times since Tue, Nov 4, 2014
    How to Restore Windows System State
    Viewed 2901 times since Sun, Aug 16, 2015
    How to configure the MS SQL Attix5 Pro Plugin
    Viewed 6039 times since Fri, May 16, 2014
    How to setup Attix5 VirtualRestore
    Viewed 2510 times since Wed, May 28, 2014
    Configure SQL 2005 & 2008 Express for Attix5 SQL Plugin
    Viewed 2379 times since Fri, May 16, 2014
    How to backup a MS SQL database using the Attix5 VSS plug-in
    Viewed 7002 times since Wed, Nov 12, 2014