Source:Web MS SQL Restore
Overview
This article describes how to restore one or more MS SQL databases online. For details on how to restore MS SQL databases by changing the database name and the disaster recovery procedure, see MS SQL Restore in the GUI.
Starting with SEP sesam v. 5.0.0 Jaglion it is possible to restore MS SQL Server databases using the web interface Restore Assistant if you have been granted the appropriate permissions. For details on its requirements, see Restore Assistant.
SEP sesam allows a complete or selective restore of MS SQL databases to the original or to a new location with relocation. In the advanced UI mode you can also write backups to the dump files.
Before attempting to restore MS SQL databases, prerequisites must be met and all preparatory steps must be performed properly, including configuration and backup. For details, see MS SQL documentation.
Accessing the restore assistant
You can access the Restore Assistant from the SEP sesam GUI by clicking the Restore Assistant icon on the toolbar, from Activities -> Restore Assistant, or by entering the following information in the browser address bar:
http://[sesamserver]:11401/sep/ui/restore/
Note | |
If you cannot access the web Restore Assistant, verify that you have been granted the appropriate permissions to perform an online restore. For more information, see About Authentication and Authorization. |
Restoring MS SQL Server databases
In the web Restore Assistant, you can restore MS SQL backups to the file system by performing a complete or selective restore. When restoring to the original location, you have to select one of the appropriate options to overwrite existing items. This means that a database that may already exist on the target server will be replaced with the restored version. To avoid overwriting the existing database, you can restore a database to a new location.
Warning | |
You can restore one or more databases at the same time only if you are restoring MS SQL databases to the original location. When restoring MS SQL databases to a new location, you can only restore one database at a time. |
If you switch from basic to advanced restore mode (click the Advanced View option), you can also write backups to the dump files. Note that the basic restore mode is enabled by default. For more details, see Setting UI mode.
Performing complete or selective restore
The complete and selective restore procedures are almost identical, only selective restore requires you to select one or more databases. When you restore MS SQL databases in advanced UI mode, an additional Options tab is available where you can specify advanced restore options.
- Open the Restore Assistant in the browser.
- In the Start window, select Microsoft SQL Server or Restore of SQL Server databases if below Advanced View option is selected. Click Next.
- In the Client window, select your MS SQL client.
- In the Task window, under the Task selection, select your backup task. A backup task defines the source data that was backed up by the client.
- If you are performing a selective restore, select a single database in the Files window and click Next.
- In the Target window, first select the target client for the restore. You can filter the clients by name, location, and OS.
- The Restore to the original target path option is enabled by default. Skip this option to restore the files to the original location. Uncheck this option if you want to restore your data to a new restore target with relocation, and specify the new target path; you can type or browse the path where you want to restore your data.
- Under the Execution options, you can set additional restore options:
- Do not overwrite existing items: The database is not restored if it already exists on the set target.
- Overwrite existing items: If the data exists on the target server, it will be replaced with the restored version. This option must be selected if restoring to the original location.
- Among the Recovery State Options, you can select one of the following database recovery options:
- Leave the database ready for use by rolling back uncommitted transactions. Additional transaction logs cannot be restored. Additionally, you can also preserve the replication settings and/or restrict access to the restored database.
- Leave the database non-operational, and do not roll back uncommitted transactions. Additional transaction logs can be restored.
- Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a file so that recovery effects can be reversed. In this case, you must also specify the name of the file Standby File.
- The Options tab (available only in the advanced mode) allows you to set the following options: Under Optional data source selection, you can select your preferred media pool, drive, used media|barcode, and interface from the drop-down lists.
- Use the Log, Special Options tab to change the log level for your specific restore, see Setting Log Level. You can specify additional commands that may be useful for specific options of the sbc command. For details about the commands, see SBC CLI.
- Use the EOL, Generation, Pre/Post tab if you want to specify the EOL parameter for the restore (how long (in days) the restore task is kept), enable/disable a generation restore, and specify whether to apply a pre- or post-script to the restore task, see Pre/Post options.
- In the final step, review your restore task and click Start restore.
Tip | |
You can search for a file or directory by entering your search term in the Search for files or directories in all backups field. |
Under the Backup selection, select the exact backup version you want to restore. You can use the calendar feature in the upper right corner to filter a date range for the displayed backups.
Then select whether you want to perform a selective or complete restore and click Next. Note that a selective restore requires an additional step. For a complete restore, you are immediately taken to step 5 (Target tab).
When you have made all the settings, click Next. Note that if you are restoring in the advanced mode, you can set additional restore options in the next step (Options tab). In basic restore mode, you are immediately taken to the last step.
The Include/ Exclude Filter tab allows you to specify which files or directories you want to include or exclude from the restore, for example, enter *.docx in the appropriate filter to include or exclude all MS Word *.docx files from the restore. You can use the include or exclude filter on the client side or the exclude filter on the server side. The latter is not available for complete restores.
Under the Advanced restore options, you can further refine your restore:
When you have set everything, click Next.
Monitoring restores
You can view the status of your restore jobs via SEP sesam Web UI (Monitoring -> Restores) or SEP sesam GUI (Main Selection -> Job State -> Restores). For details, see Monitoring and Reporting.