In the following example, we describe how to make a copy of a database named 'Marketing' that originally exists at 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA' with a name 'MarketingTeam' that will be created at 'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA'.
This database needs to be renamed 'MarketingTeam' and and restored to 'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA'.
- Go to the Restore page and select the 'Marketing' database in the File Path view.
- It is not necessary to select the database in all of the full, differential, and/or incremental backup runs. If one selects the 'Marketing' database in any one backup run, ZCB will automatically select 'Marketing' database from all other backup runs that are required for restore.
- From the 'Restore Method' drop down, select 'Restore a Copy of Database to Original or New Location' option.
- The 'Edit Database Name & Restore Path' dialog box will appear.
- Specify the new name 'MarketingTeam' in the 'New Name' field.
- Click inside the 'Path' field and browse to the target folder
- i.e.'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA'.
- Save the changes.
- (Optional) Select the 'Run DBCC CHECKDB' check box if you wish to verify the logical and physical integrity of all the objects in the specified database(s) after the restore completes.
- Click on the Restore button.
- A confirmation box will appear. Click OK to restore or Cancel to cancel.
- After restore completes, both the 'Marketing' & 'MarketingTeam' databases will appear in the SQL Management Studio.