Rename/Redirect Files on Restore - How To

Topics | How To | Related Topics

Rename Files on Restore (File System)

Redirect/Rename Data During DB2 Restore

Redirect/Rename Data During Oracle Restore

Restore a Database with a Different Name (Move a Database) (SQL)

Restore with a Different Data File Path (Copy a Database) (SQL)

Rename Files on Restore

Before You Begin

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore.

Required Capability: See Capabilities and Permitted Actions

To rename files on restore:

1. From the CommCell Browser, right-click the agent, instance or backup set that contains the data you want to rename on restore, click All Tasks and then click the available Browse command (command names vary by agent).
2. Run a browse operation. See Browsing Data for a list of customized browse operations and their step-by-step instructions. If you accept all defaults, you will be browsing the latest backups for the selected data.
3. From the Browse window, Select Objects From the Browse Window for Restore.
4. From the Restore Options (General) dialog box, click Advanced.
5. From the Map tab in the Advanced Restore Options dialog box, enter the desired string that you want to append as a suffix to the filenames in the Rename all restore files with suffix field and click OK.
6. Optionally, you can select any additional restore options that you want to use from the tabs in the Advanced Restore Options and Restore Options dialog boxes. Then click OK.
7. If you want to schedule the job, click the Job Initiation tab from the Restore Options dialog box, click Schedule, schedule the job, and then click OK. If you want to run the job now, accept or click Run Immediately in the same tab and then click OK. The progress of the restore job can be monitored using the Job Controller.

Redirect/Rename Data During DB2 Restore

Before You Begin

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore.

Required Capability: See Capabilities and Permitted Actions

To redirect and/or rename data during a DB2 restore:

1. From the CommCell Browser, right-click the DB2 backup set that contains the data you want to rename/redirect on restore, click All Tasks and then click the available Browse command (command names vary by agent).
2. Run a browse operation. See Browsing Data for a list of customized browse operations and their step-by-step instructions. If you accept all defaults, you will be browsing the latest backups for the selected data.
3. From the Browse window, Select Objects From the Browse Window for Restore.
4. From the Source & Destination and Restore Arguments tabs of the DB2 Restore Options dialog box, and from the Job Initiation tab of the Restore Options dialog box, select the options that you want to use.
5. Click Advanced.
6. From the Redirect tab of the Advanced Restore Options dialog box, redirect and/or rename data for the restore operation.  Specifically, do one of the following:
   • If you want to redirect all the table spaces selected for restore to a new location, then select the Redirect All Table Spaces to: checkbox and either type in a new location in the corresponding entry field or click Browse to display the Browse for Restore Redirect Path window and navigate to the new location.
   • If you want to redirect one or more tablespaces to a new location, then select the Redirect Table Space Containers checkbox and click the desired table space to highlight it. When you do this, the Container Name path for the table space appears below. Click this path, click Edit, and update as appropriate in the Editing Container Name of Table Space dialog box. Use the Browse button if necessary. Then click OK.  Repeat this procedure for each appropriate tablespace. Then click OK.
7. Click OK to save your entries. This closes the Redirect tab.
8. Select any additional restore options from the tabs for the Advanced Restore Options dialog box and then click OK.
9. If you want to schedule the job, select the Job Initiation tab from the Restore Options dialog box, click Schedule, schedule the job, and then click OK. If you want to run the job now, accept or click Run Immediately in the same tab and then click OK. The progress of the restore job can be monitored using the Job Controller.
10. After the data has been restored, you will see a job completion message in the Job Controller and Event Viewer.

Redirect/Rename Data During Oracle Restore

Before You Begin

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore.

Required Capability: See Capabilities and Permitted Actions

To redirect tablespaces and/or rename datafiles during an Oracle restore:

1. From the CommCell Browser, right-click the Oracle agent or instance that contains the datafiles you want to rename/redirect on restore, click All Tasks and then click the available Browse command (command names vary by agent).
2. Run a browse operation. See Browsing Data for a list of customized browse operations and their step-by-step instructions. If you accept all defaults, you will be browsing the latest backups for the selected data.
3. From the Browse window, Select Objects From the Browse Window for Restore.
4. From the General tab of the Oracle Restore Options dialog box, and the Job Initiation tab of the Restore Options dialog box, select the options that you want to use.
5. Click Advanced.
6. From the Redirect tab of the Advanced Restore Options dialog box, redirect tablespaces and/or rename datafiles for the restore operation.  Specifically, do one of the following:
   • If you want to redirect all the tablespaces selected for restore to a new location, then select the Redirect All Table Spaces to: checkbox and either type in a new location in the corresponding entry field or click Browse to display the Browse for Restore Redirect Path window and navigate to the new location.
   • If you want to redirect only certain tablespace(s) or datafile(s) to a new location, then select the Redirect checkbox, click the desired object(s) in the Object column to highlight them, and either type in a new location in the New Path entry field or click the Browse button to the right of the New Path field to display the Browse for Restore Redirect Path window and navigate to the new location. After specifying the New Path, click Apply. The specified location will now display in the New Path column next to the selected object(s).
   • If you want to redirect all datafiles for a tablespace, select the Redirect checkbox, select the desired tablespace from the Object column, and type in a new path in the New Path entry field. After specifying the new path, click Apply. The new path for the datafiles will now display in the New Path column next to the selected tablespace.
   • If you want to rename one datafile for a tablespace, select the Redirect checkbox, expand the desired tablespace then select the desired datafile, and type in the full path with a new name in the New Path entry field. After specifying the new name, click Apply. The new name for the datafile will now display in the New Path column next to the selected datafile.
7. Click OK to save your entries. This closes the Redirect tab.
8. Select any additional restore options from the tabs for the Advanced Restore Options dialog box and then click OK.
9. If you want to schedule the job, select the Job Initiation tab from the Restore Options dialog box, click Schedule, schedule the job, and then click OK. If you want to run the job now, accept or click Run Immediately in the same tab and then click OK.

   Before the restore job is run, the system will check whether the database is in the correct mode for this type of restore. If it is not, a message dialog will inform you of this and offer to automatically switch the database into the valid mode. When this happens, either click Yes on the message dialog to have the system automatically switch the database to the valid mode and continue the restore, or click No to manually switch the database to the valid mode before proceeding.

10. The progress of the restore job can be monitored using the Job Controller.
11. After the data has been restored, you will see a job completion message in the Job Controller and Event Viewer.

Restore a SQL Server Database with a Different Name (Move a Database)

Before You Begin

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.
• VSS-enabled backup jobs must be restored to the exact server, database, and file name from which they originated.
• If you are attempting to rename a database and keep its original path, you must first delete the original database from SQL Server before performing this restore. This procedure attempts to restore the renamed database to the same path as the original database. Should the original database still exist at this path, the restore will fail. Alternately, you can rename the database and change its path without deleting the original database. For this option, refer to Restore with a Different Data File Path (Copy a Database).
• For File/File Group restore jobs, you must perform a complete restore of all database files in order to restore to a different SQL Server instance.

  System databases cannot be moved. System databases cannot be restored on top of exiting system databases on a different instance (also considered a move operation). System databases can restore on top of the same database on the same instance provided the database name and filenames are not changed (i.e., an in–place restore). System databases can be restored to any SQL instance provided both the database name and filenames are changed.

Required Capability: See Capabilities and Permitted Actions

To restore a SQL Server database with a different name:

1. Begin any SQL Server restore procedure.
2. When you reach the SQL Restore (General) dialog box, click Advanced.
3. From the Options tab of the Advanced Restore Options dialog box, in the Database column, click each database you want to rename, and change the name to the new value. When a change is made to one database in this column, the change is automatically propagated to the other files of the same database.
4. Continue your restore.

Restore with a Different Data File Path (Copy a Database)

Before You Begin

• Review the general and agent-specific restore requirements accessed from Restore Backup Data prior to performing any restore operation.

• You can change the path for data files being restored for any level of restore. This is useful in situations in which you are performing a restore and the default path cannot be used for any reason, such as the following examples:

  • a destination server does not have the corresponding path
  • when restoring the database to the same server, but restoring the database under a different name.

Required Capability: See Capabilities and Permitted Actions

To restore with a different data file path:

1. Begin any SQL Server restore procedure.
2. When you reach the SQL Restore (General) dialog box, click Advanced.
3. From the Options tab of the Advanced Restore Options dialog box, in the Physical Path column, click each of the files of the database you want to redirect and change the path and/or filename to a new value. If there are many files in the database you want to move, click Find & Replace and enter the necessary values to change them all at once. If the path entered does not exist, it will be automatically created during the restore operation.
4. Continue the restore procedure.