Source:Web MS SQL Restore

From SEPsesam
Revision as of 16:13, 10 August 2021 by Sta (talk | contribs) (Jaglion draft, in progress.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Draft.png WORK IN PROGRESS
This article is in the initial stage and may be updated, replaced or deleted at any time. It is inappropriate to use this document as reference material as it is a work in progress and should be treated as such.
Copyright © SEP AG 1999-2024. All rights reserved.

Any form of reproduction of the contents or parts of this manual is allowed only with the express written permission from SEP AG. When compiling and designing user documentation SEP AG uses great diligence and attempts to deliver accurate and correct information. However, SEP AG cannot issue a guarantee for the contents of this manual.

Docs latest icon.png Welcome to the latest SEP sesam documentation version 5.0.0 Jaglion. For previous documentation version(s), check Documentation archive.


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/

Information sign.png 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.

SEP Warning.png 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.

  1. Open the Restore Assistant in the browser.
  2. In the Start window, select Microsoft SQL Server or Restore of SQL Server databases if below Advanced View option is selected. Click Next.
  3. Restore assistant MS SQL start Jaglion.jpg
  4. In the Client window, select your MS SQL client.
  5. Restore assistant MS SQL client Jaglion.jpg
  6. 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.
  7. SEP Tip.png 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.

    Restore assistant MS SQL select task Jaglion.jpg
    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).

  8. If you are performing a selective restore, select a single database in the Files window and click Next.
  9. Restore assistant MS SQL select database Jaglion.jpg
  10. In the Target window, first select the target client for the restore. You can filter the clients by name, location, and OS.
  11. Restore assistant MS SQL select target Jaglion.jpg
  12. 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.
  13. Restore assistant MS SQL target path Jaglion.jpg
  14. 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.
  15. 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.
    • Restore assistant MS SQL recovery options Jaglion.jpg

    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.

  16. The Options tab (available only in the advanced mode) allows you to set the following options:
  17. Under Optional data source selection, you can select your preferred media pool, drive, used media|barcode, and interface from the drop-down lists. Advanced options optional data Jaglion.jpg
    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. Advanced options filter Jaglion.jpg
    Under the Advanced restore options, you can further refine your restore:
    • 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.
    • Advanced options log Jaglion.jpg
    • 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.
    • Advanced options EOL Jaglion.jpg

    When you have set everything, click Next.

  18. In the final step, review your restore task and click Start restore.

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.

See also

Restore AssistantMS SQL Restore in the GUI