The centralized restore of multiple databases includes the following restrictions:
A multi-database restore can restore only the most recent database backups.
If you need to restore older backup copies of multiple databases, then perform a single database restore of each older backup copy, one at a time.
A multi-database restore can restore only to the original database names.
If you need to restore multiple databases and rename the databases, then perform a single database restore of each backup copy, one at a time.
A multi-database restore does not support the tail-log backup option.
Multiple databases are restored serially (one at time).
A multi-database restore also supports partial success:
If a given database exists on the target host and the overwrite option is not specified, the database restore is not attempted and the next database restore is attempted.
If the restore fails for a given database, the next database restore is attempted.
Steps
In the
PowerProtect Data Manager UI, select
Restore > Assets and select the
SQL tab.
The
Restore window displays all the databases that are available for restore.
To filter the displayed list of assets if needed, you can click the
Host/Cluster/Group Name,
Application Name, and
Protection Type column headings:
The
Host/Cluster/Group Name column lists the hostnames.
The
Application Name column lists the SQL instance names.
The
Protection Type column lists the Application Direct or VM Direct protection type for each asset.
NOTE Only the assets that were created by a SQL Application Direct or virtual machine application-aware protection policy and have at least one copy are displayed. You can select assets only from the same SQL host and instance.
Select the check box next to each database that you want to restore, or in a filtered view, select multiple databases through a check box in a column heading, and then click
Restore.
The restore wizard opens on the
Select Copy page.
On the
Select Copy page, click the
DD icon in the left pane for the primary or secondary source DD.
The right pane displays a message that the restore operation uses the latest copy on the storage target, when available. The most recent full or transaction log backup copy is restored.
NOTE If a transaction log backup is the most recent copy, the entire backup chain from the base full backup is restored. If you need to restore older backup copies, use a single database restore to restore the backup copies one at a time.
Click
Next to continue.
On the
Select Destination page, the
Host and
SQL Instance fields are prepopulated, but you can click
Select for each field to specify the host and instance as needed.
NOTE
SQL system databases (master, model, msdb) can only be restored to the original host and SQL instance. If the required host is not listed, follow the instructions in
Application agent manual installation and configuration.
If you specify a SQL instance that is part of an Always On Failover Cluster Instance, the database restore is directed to the active node.
Click
Next to continue.
On the
Select File Location page, select one of the following options for
Restore database files to, and then click
Next:
Original file location (location at backup time)
NOTE If the directory path cannot be created during the centralized restore, the restore fails.
Default file location as set by Microsoft SQL Server
User-specified file location
NOTE
When you select this option, you must specify the restore file directories for the database files and log files.
To restore a database to a different name, ensure that you specify a custom destination directory that is different from the directory that contains the source
mdf and
ldf files.
On the
Select Options page, select any the following options, and then click
Next:
Overwrite Databases WITH REPLACE—Overwrites the existing databases during the restore operation.
NOTE When a database exists but the
Overwrite Databases WITH REPLACE option is not selected, the restore fails.
Compressed Restore—Uses DD Boost compression for the restore operation.
Disconnect Users—Disconnects the database users before the restore operation.
Troubleshooting—Enables the debug log, setting the debug level to a value of 9.
Restore State—Select one of the following options:
RESTORE WITH RECOVERY—Leaves the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored.
RESTORE WITH NO RECOVERY—Leaves the database nonoperational and does not roll back the uncommitted transactions. Additional transaction logs can be restored.
On the
Summary page:
Review the
Source,
Destination,
File Location, and
Options information to ensure that the restore details are correct.
NOTE When the specified database name matches the name of an existing database, the restore overwrites the existing database.
Click
Restore.
The restore operation starts. Then the
Go to Jobs informational dialog box appears with a link to the
Jobs page where you can monitor the restore job.
Data is not available for the Topic
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please select whether the article was helpful or not.
Comments cannot contain these special characters: <>()\