SQL Safe allows you to restore multiple databases or files to any SQL Server instance you have registered. Ensure each registered instance is running the SQL Safe Backup Agent. Depending on your needs, you can restore databases from specific backup sets, or use the intuitive user interface to select specific points in time for each database you want to restore. When you select a time, SQL Safe automatically selects the appropriate backup sets that contain the data to be restored.
The Restore wizard will walk you through the restore process. Use the following checklist to ensure you have everything in place to restore your databases to the correct locations and to the correct points in time.
| Follow these steps ... |
| Determine the location of the databases you want to restore to the SQL Server instance in question. |
| Determine which SQL Server instance should host the recovered databases. |
| For each database you need to recover, decide whether you will be restoring data from a specific backup set, or if you will restore data to a specific point in time. You can select the specific one in the Restore wizard. |
| Determine whether you want and are able to use InstantRestore. |
To restore a database on a routine schedule, use a restore policy to maintain an up-to-date copy of your database.
What does the Restore wizard do?
The SQL Safe Restore wizard allows you to simultaneously restore multiple databases on different SQL Server instances, restore multiple databases on the same SQL Server instance, or restore individual databases. SQL Safe also allows you to verify the integrity of a backed up database without restoring it.
What is InstantRestore?
InstantRestore allows you to quickly come back on line while restoring your database. It is important to understand InstantRestore fully before undertaking this type of database restore. Make sure you know the supported restore information before attempting to use the InstantRestore feature. Note that InstantRestore supports only complete database restores and does not support file or filegroup restores.
How do you restore a backup using the Restore Wizard?
You can restore your backups with the SQL Safe Restore Wizard by accessing it from the following paths:
- Go to the task bar, click Restore, and select Database(s) or Database files.
- From any tab, go to the File menu, select Restore, and choose Database(s) or Database files.
- Go to the Common Tasks bar of the SQL Safe Today view and click Restore Database.
- In the Servers tree, select the SQL Server instance or specific database you want to restore. Right click on it and select according to your needs either: