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 Backup Capita SIMS Using the Attix5 Plugin
    Viewed 2301 times since Tue, Apr 12, 2016
    How to backup a MS SQL database using the Attix5 VSS plug-in
    Viewed 6674 times since Wed, Nov 12, 2014
    How to Setup Email Notifications
    Viewed 2408 times since Sat, Aug 15, 2015
    How to use Attix5 VirtualRestore
    Viewed 1121 times since Wed, May 28, 2014
    Configure SQL 2005 & 2008 Express for Attix5 SQL Plugin
    Viewed 2236 times since Fri, May 16, 2014
    How to Restore Windows System State
    Viewed 2304 times since Sun, Aug 16, 2015
    Enable VSS writer for Exchange 2003 servers
    Viewed 3061 times since Tue, Nov 11, 2014
    How to backup an Exchange server using the Attix5 VSS plugin
    Viewed 5030 times since Tue, Nov 4, 2014
    How to setup Attix5 VirtualRestore
    Viewed 2316 times since Wed, May 28, 2014