Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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'.

  1. Go to the Restore page and select the 'Marketing' database in the File Path view.
    1. 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.
  2. From the 'Restore Method' drop down, select 'Restore a Copy of Database to Original or New Location' option.
  3. The 'Edit Database Name & Restore Path' dialog box will appear.
    1. Specify the new name 'MarketingTeam' in the 'New Name' field.
    2. Click inside the 'Path' field and browse to the target folder
      1. i.e.'E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA'.
    3. Save the changes.
  4. (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.
  5. Click on the Restore button.
  6. A confirmation box will appear. Click OK to restore or Cancel to cancel.
  7. After restore completes, both the 'Marketing' & 'MarketingTeam' databases will appear in the SQL Management Studio.

...