CyberSecure™ Microsoft® SQL Server Restoration Guide

sql server offsite backup
Document Version: 1.0

Please follow the instructions below to restore Microsoft SQL Server from the CyberSecure offsite backup network.

Applies to versions: 2000

  1. Download the .BAK files through the CyberSecure client.
  2. Open Microsoft SQL Enterprise Manager
  3. Optional - Restore the MASTER database

    The MASTER database is required to be restored if you are:

    • rebuilding all databases from scratch
    • have added logins or other security-related operations
    • have created or removed logical backup devices
    • have configured the server for distributed queries and remote procedure calls, such as adding linked servers or remote logins
    You don't need to restore the MASTER database if you just want to restore a user database.

    To restore the MASTER database:

    1. Start SQL Server in "Single User Mode"
      1. Right-click your SQL server and choose Properties
      2. Press the Startup Parameters button
      3. Add a "-m" parameter to the Startup Parameters
      4. Stop/start Microsoft SQL server
    2. Restore the MASTER database
      1. From [Enterprise Manager] -> [Tools] ->
      2. Select [master] in the [Restore as database] drop down list
      3. Select the [From device] radio button
      4. Press the [Select Devices] button
      5. From the [Choose Restore Devices], press the [Add] button
      6. From the [Choose Restore Destination] panel, press the [...] button to choose your MASTER backup (*.bak) from your backup files
      7. Press the [OK] button to start restoring the MASTER database
    3. Restart MS-SQL server in "Normal Mode"
      1. Remove the "-m" parameter from the [Startup Parameters] from the previous step
      2. Restart your MS-SQL server as detailed previously
  4. (Optional) Restore MODEL, MSDB, DISTRIBUTION databases

    You will need to restore the MODEL databse if you have changed the database template of your SQL server.

    You will need to restore the MSDB database if you have changed the scheduling information or if you want to restore the backup and restore history of your databases.

    You will need to restore the DISTRIBUTION database if you are running the replication components of SQL server

    You do not need to restore these databases if you only want to restore a user database.

    Each database needs to be restored one-by-one. To restore any of these databases:

    1. From [Enterprise Manager] -> [Tools] -> [Restore Database]
    2. Select the database to be restored in the [Restore as database] drop-down list
    3. Select the [From device] radio button
    4. Press the [Select Devices] button
    5. Press the [...] button to choose your backup file (*.BAK) for the database to be restored
    6. Press the [OK] button
  5. Restore user databases

    For each database:

    1. From [Enterprise Manager] -> [Tools] -> [Restore Database]
    2. Select the database to be restored in the [Restore as Database] drop-down list
    3. Select the [Database] radio button
    4. From the [Show backups of database] drop-down list, select the database to be restored
    5. From the [First backup to restore] drop-down list, select the snapshot of the database you would like to restore.

      The database can be restored back to any point in time since the last full backup

    6. Change the [Restore From] entry

      If your backup files (*.BAK) are not in the default directory, you will need to update the full path to your backup files by pressing the [Properties] button.

  6. You should now have a complete restored Microsoft SQL Server