Page History
...
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. |
| Tip |
|---|
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:
...
| Scroll pdf ignore | |||||||||
|---|---|---|---|---|---|---|---|---|---|
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > > | IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal