Source:Web MS SQL Restore: Difference between revisions

From SEPsesam
mNo edit summary
m (Corrected option's name)
Line 67: Line 67:
<translate><!--T:29--> [[image:Restore_assistant_MS_SQL_start_Jaglion.jpg|600px|link=]]</translate>
<translate><!--T:29--> [[image:Restore_assistant_MS_SQL_start_Jaglion.jpg|600px|link=]]</translate>
<br clear=all>
<br clear=all>
<li><translate><!--T:30--> In the ''Client'' window, select your MS SQL client.</translate></li>
<li><translate><!--T:30--> In the ''MS SQL Server'' window, select your MS SQL client.</translate></li>
<translate><!--T:31--> [[image:Restore_assistant_MS_SQL_client_Jaglion.jpg|600px|link=]]</translate>
<translate><!--T:31--> [[image:Restore_assistant_MS_SQL_client_Jaglion.jpg|600px|link=]]</translate>
<br clear=all>
<br clear=all>

Revision as of 16:36, 17 December 2021

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.
Other languages:

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.

Now 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 complete or selective restore of MS SQL databases to the original or to a new location with relocation. In advanced UI mode, you can also write backups to 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 Backup.

Accessing the restore assistant

You can access the restore assisstant in one of the following ways:

  • via the GUI: by clicking the Restore Assistant icon in the toolbar or from Activities -> Restore Assistant
  • from SEP sesam Web UI: left menu -> Restore Assistant
  • or by entering the following address in the browser bar: http://[sesamserver]:11401/sep/ui/restore/.
Information sign.png Note
  • If you cannot access the web Restore Assistant, check if you have received the appropriate permissions for online restore. For details, see About Authentication and Authorization.
  • The operations and options available after logging in may differ depending on the user type. Other Web UI display restrictions may depend on the custom roles with specific permissions and the UI mode.
    For details, see User Roles and Permissions.

Restoring MS SQL Server databases online

With 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 only restore one or more databases at a time if you restore MS SQL databases to the original location. If you are 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 dump files. Note that the basic restore mode is enabled by default. For more details, see Setting UI mode.

Performing complete or selective restore

Complete and selective restore procedures are almost identical, except that 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 set advanced restore options.

  1. Open the Restore Assistant in the browser.
  2. In the Start window, select Microsoft SQL Server. If you want to perform MS SQL restore in the advanced UI mode, you also have to select Advanced View and then Restore of SQL Server databases. Click Next.
  3. Restore assistant MS SQL start Jaglion.jpg
  4. In the MS SQL Server 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.

    Under the Backup selection, select the exact backup version you want to restore. You can use the calendar function in the upper right corner to set a date range for the 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).
    Restore assistant MS SQL select task Jaglion.jpg

  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 data is restored only if it does not already exist on the target system.
    • Overwrite existing items: If the data exists on the target server, it is 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 will be taken to the last step immediately.

  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 Retention, Generation, Pre/Post tab if you want to specify the retention period 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 retention Jaglion.jpg

    When you have set everything, click Next.

  18. In the last step, check the summary of your restore task (restore type (based on task type, selected backup, its date and details, restore options, etc.) and click Start restore.
  19. Restore assistant MS SQL finish Jaglion.jpg

Restoring MS SQL databases by writing the backups to dump files

When you start MS SQL Server web restore, you can also write the backups to dump files and restore the data to a single file rather than to its original location. In this case, you must specify a restore destination path in the Target window (by browsing or typing the path). Optionally, you can also change the name of the dump file. If the dump file name is not specified, it is generated automatically.

Note that you can also use the same option with an identical procedure when restoring files, directories, or emails in the advanced UI mode.

  1. Open the Restore Assistant in the browser.
  2. In the Start window, select Microsoft SQL Server. Then select Advanced View and Write backups into dump files. Click Next.
  3. MS SQL web restore start dump Jaglion.jpg
  4. Under the Backup selection, select the exact backup version you want to restore. You can use the calendar function in the upper right corner to set a date range for the backups. You can also filter the backups by States and/or Event types, and search for specific tasks or clients. Note that for MS SQL backups, the Generation Restore option is enabled by default. Click Next.
  5. MS SQL web restore select backup dump Jaglion.jpg
  6. In the Target window, specify the following target options:
    • Select the target client for the restore.
    • Specify a target path for the restore (by browsing or typing the path). Optionally, specify a name for the dump file. If the dump file name is not specified, it is generated automatically.
    • Select the appropriate Execution option. Note that the options depend on the backup selected, but generally the following options are available:
    • Do not overwrite existing items: The database will not be restored if it already exists on the set target.
      Create new version: The files will be restored under a new name.
      Overwrite existing items: If the data exists on the target server, it will be replaced with the restored version.
      Skip ACL settings during restore: If this option is selected, the preconfigured ACL settings are skipped during restore.

    MS SQL web restore target dump Jaglion.jpg
    When you have completed all the settings, click Next.

  7. In the Options tab, you can set additional restore options (optional data source selection, include/exclude filters, and advanced restore options) described in the previous section. Click Next.
  8. In the last step, check the summary of your restore task (restore type (based on task type, selected backup, its date and details, restore options, etc.) and click Start restore.
  9. MS SQL web restore finish dump Jaglion.jpg

Monitoring restores

You can monitor the restore progress using the Web UI (Monitoring -> Restores) or view the status in the GUI (Main Selection -> Job State -> Restores). The restore overview provides detailed information on the last run of restore jobs, including task name, status (successful, error, in queue ...), start and stop time of the last backup, data size, throughput, etc. For details, see SEP sesam Web UI or Restores by State in the GUI.