Restore command

Edit online

Use this command to restore one (or more) SQL databases from storage that is managed by IBM Storage Protect Snapshot to a SQL Server.

Considerations:
  • You cannot restore SQL databases currently in use. By placing SQL databases to be restored in single-user mode, you can avoid attempting such restores. If you are restoring the master database, you must start the SQL Server in single-user mode by using the -m SQL SERVER startup option.
    Note:
    1. The single user of the SQL databases or server must be the same user that IBM Storage Protect Snapshot uses to log on to the SQL Server for the restore.
    2. SQL Enterprise Manager, SQL Server Application Client, and other SQL Server services can be users of databases and the SQL Server.
  • The user that is used by IBM Storage Protect Snapshot to log on to the SQL Server must have the SQL Server SYSADMIN fixed server role.
  • You can use the TRANSACT-SQL database consistency checker statement DBCC CHECKDB ('DBNAME') to verify the integrity of the restored SQL databases.
  • Restore syntax Use the restore command syntax diagrams as a reference to view available options and truncation requirements.

  • Restore positional parameters

    Positional parameters immediately follow the restore command and precede the optional parameters.

  • Restore optional parameters

    Optional parameters are used with the restore command and positional parameters.

  • Restore output examples

    These output examples provide a sample of the text, messages, and process status that displays when you use the restore command.