1. Find the server that has the SQL database which needs restored. Expand the SQL Server agent under the server name to view all the SQL Instances. Bring up the “Browse and Restore” by right clicking SQL Instance name in the left column.
2. After clicking “Browse and Restore” you will be given a few different options for your Intended Restore type. Once your intended Restore Type and Time are selected, click “View Content”. (Please see the note below about selecting the restore time before continuing)
3. Please select the desired Restore Option to continue from the list below that was selected in step 2.
Restores the Database to the original location and Instance. (This will overwrite the original Database!)
- Select the SQL Database(s) that needs restored and then click “Recover All Selected…”.
- Since you selected to restore in place you will not be able to change any options on the “SQL Restore Options” page. Please verify that the SQL Server\Instance and Database(s) listed on this page are correct as this is what will be overwritten.
Click OK to start the restore once all settings are verified. (This will overwrite the original Database!)
Restores database using a different name, file path, or instance. (Restore to a new Database name or overwrite an existing Database on the original or different destination server with a Commvault SQL Agent installed.)
- Select the SQL Database(s) that needs restored and then click “Recover All Selected…”.
- Once the SQL Restore Options come up, choose the Destination Server and SQL Instance at the top of the screen. Next, type the new Database Name(s) and File Paths for the restored Database and Log files. Make sure to change the Database names and files paths to something unique that isn’t currently in SQL on the destination server.
-
- To overwrite an existing Database(s) on the destination server, change the name for the restored database in the Database column to match the exact name of the database you want to overwrite. Also make sure to match the Database Files for the Database(s) that will be overwritten so that the old .MDF and .LDF files are overwritten as well.
- Database files are .MDF and log files are .LDF. You can also see how much free space will be required on the drive to restore each file under the Size column.
Click OK to start the restore once all settings are verified.
Restore database to disk. (Restore the Database to disk as a .BAK file to the original or different destination server with a Commvault SQL Agent installed.)
- Select the SQL Database(s) that needs restored and then click “Recover All Selected…”.
- Once the SQL Restore Options come up, choose the Destination Server at the top of the screen. Next, click the “Browse” and select the destination path to restore the BAK file too.
Notes:
-
- You must rename the databases before restoring them to a disk, either on the same SQL server or a different SQL Server.
- For each backup type, one file is created per stream. The naming convention of the file is <DB_name>_<Stream#>_<BackupType>_<DayofWeek, Month, Day, Time, Year>.bak, where date and time are the date and time of the database backup.
Click OK to start the restore once all settings are verified.
Recover the original Instance. (This will overwrite the entire original SQL Instance!)
- Since you selected to restore the entire SQL Instance, all Databases will automatically be selected for restore. Please click “Recover All Selected…” to proceed to the next screen.
- Since you selected to restore the entire SQL Instance, you will not be able to change any options on the “SQL Restore Options” page. Please verify that the SQL Server\Instance and Database(s) listed on this page are correct as this is what will be overwritten.
Click OK to start the restore once all settings are verified. (This will overwrite the entire original SQL Instance!)
Advanced Restore: Restore database with advanced capabilities. (Used to specify “Recovery”, “Norecovery” or “Stand By” Recovery Types)
Recovery Types and Undo Path
Specifies the type of recovery that must be performed. This is the state of the database after the restore.
- Recovery
Selecting this option to restore a database leaves the database in an online state.
- Norecovery
Selecting this option to restore a database leaves the database in a restoring state.
- Stand By
Selecting this option to restore a database leaves the database in a read-only state.
- Undo File Path
Displays the path in which the undo file is stored, when the Recovery Type is Stand By. Use the space to modify the default path.
Once the restore is complete, the SQL Server Agent uses the data from the undo file and the transaction log to continue restoring the incomplete transactions. Therefore, once the restore completes, the undo file is re-written with any transactions that are incomplete at that point.
- Browse
Click to select a path for the Undo File Path.