Loading...

Copying a SQL Server Database to a Different Location

You can restore a database to a different location on the same destination server.

Procedure

  1. From the CommCell Browser, click Client Computers > client > SQL Server.
  2. Right-click the instance, and then click All Tasks > Browse and Restore.
  3. In the Browse and Restore Options dialog box, click Advanced Restore, then click View Content.
  4. In the browse view, select the data that you want to restore, and click Recover All Selected.

    The SQL Restore Options dialog box appears.

  5. In the Database column, type the new database name.
  6. To change the database and log files path, in the Physical path column, type the full path to the new location.

    Note: If there are many files, use the Find & Replace option to enter the new destination path for all of them at once.

    If the database file path is changed without changing the database name, the existing database will be overwritten and will point to the new location.

  7. Click OK.

Last modified: 6/11/2020 6:01:21 PM