In this tutorial I will guide you through the SnapManager for SQL Restore Wizard. You must of already created a successful backup of an SQL database to be able to restore.

1. Launch the SnapManager for SQL application.


2. Select Restore SnapManager backups that were created on the same SQL Server and click Next.


3. Expand Microsoft SQL Servers and select the database that you wish to restore.


4. Make sure the Database is ticked, if you backed up all transaction logs you can click Point in Time and select at which date & time you wish to restore from. If you remember from my last tutorial with the Backup Wizard, I did not keep all transaction logs. Click Next.


5. Click Next.


6. Select Leave the databases operational, but unavailable for restoring additional transaction logs. Click Next.


7. You can restore the database as the same name (which will restore over the top of the original, or you can restore to a new database name. Click Next.


8. Select the SQL server you wish to restore to. I will be restoring to the same server that I took the backup from. Click Next.


9. Click Restore Setting.


10. If you are restoring over the top of an existing database you must select Restore database even if existing databases are online. Select the options that you wish to use and click Ok the click Next.


11. Review the summary of the restore job. If you wish to make any changes you can click the Back button, otherwise click Finish and the restore job will begin.


Disclaimer:
All the tutorials included on this site are performed in a lab environment to simulate a real world production scenario. As everything is done to provide the most accurate steps to date, we take no responsibility if you implement any of these steps in a production environment.

2 Comments

  1. Putting another name in for the database doesn’t work as it will use the same file path as that of the backed up database. No good if you want to restore as a test version but leave production running.

Leave a Reply

Your email address will not be published.


*


*

This site uses Akismet to reduce spam. Learn how your comment data is processed.