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. 

Warning

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.

 
Tip

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.
    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 Windows System State
    Viewed 1793 times since Sun, Aug 16, 2015
    How to perform a bare metal restore in Attix5
    Viewed 1576 times since Fri, Aug 14, 2015
    How to Backup Capita SIMS Using the Attix5 Plugin
    Viewed 1497 times since Tue, Apr 12, 2016
    How to backup MySQL on Attix5 Server Edition for Windows
    Viewed 3219 times since Fri, May 30, 2014
    How to configure the MS SQL Attix5 Pro Plugin
    Viewed 4159 times since Fri, May 16, 2014
    How to backup an Exchange server using the Attix5 VSS plugin
    Viewed 4610 times since Tue, Nov 4, 2014
    Exchange Backup Frequently Asked Questions
    Viewed 1987 times since Mon, Aug 17, 2015
    How to backup a MS SQL database using the Attix5 VSS plug-in
    Viewed 6163 times since Wed, Nov 12, 2014
    How to Setup Email Notifications
    Viewed 1943 times since Sat, Aug 15, 2015