The form allows you to restore the database manually according to an XML plan. To open this form you have to right-click on the server on the list of servers and policies. Then select Restore according to an XML Plan.
Folder connections - Connects to a network or local folder containing an XML restoration plan and backup files.
XML file name - The name of the XML Restoration Plan file.
Databases - databases which will be restored in accordance with the XML plan.
The Destination database switch defines the database where the data will be restored. Possible values:
- Databases with the same name - if this option is selected, then files will be restored to the same databases. If a particular database does not exist, it will be created. The existing database will be overwritten.
- Temporary database – if this option is selected, data will be restored to a temporary database that shoud be deleted after the completion of the task. During the execution of the task, the program will create a temporary database named in accordance with the following pattern: qmbTempRestoreDb[Random index].
- Specific database – when this option is selected, the user must select a database to be used for saving the restored data. The database will not be deleted after the completion of the task. You can select an existing database or enter the name of a new one. In the latter case, the database will be created automatically.
Check the database after backup restoration – this option allows you to run a database integrity check after restoration (DBCC CHECKDB).
See Also