Restoring a database

You can restore a database from a backup by logging in to SQL Server Management Studio as a user with syadmin access authority for the Restore Database function. (Database backups are specified as a scheduled job in Windows Task Scheduler. See Database maintenance for more information.)

Restoring the latest database

Complete the following to restore a database from the latest backup:

  1. Stop all ION services.
  2. Open SQL Server Management Studio, enter your password if required and click Connect to access your SQL Server.
  3. In the Object Explorer pane on the left, expand Databases, right-click the database you want to restore and click Tasks > Restore > Database to open the Restore Database dialog.
  4. Under Source, select Database and click the database you want to restore in the dropdown list if it is not already selected.
  5. Under Backup sets to restore, select the checkbox in the Restore column for the database you want to restore.
  6. Click Options in the Select a page pane on the left.
  7. On the Options page:
    • Under Restore options, select Overwrite the existing database (WITH REPLACE).

    • For Recovery state, select RESTORE WITH RECOVERY from the dropdown list.

      RESTORE WITH RECOVERY is described as Leave the database ready to use by rolling back uncommitted transactions. Additional Transaction logs cannot be restored.

  8. Click OK to begin the restore operation.

    A message indicates that the database has been restored successfully. If the restore operation is not successful, the database reverts to its original state.

    NOTE: After you restore the database, you need to assign its ownership to the ION user as follows:

    1. In SQL Server Management Studio, right-click the restored database and click Properties in the menu to open the Database Properties dialog.
    2. Click Files under Select a page.
    3. Click the button on the right of the Owner field to open the Select Database Owner dialog.
    4. Type ION in the field labeled Enter the object names to select and click Check Names to adjust the format of your entry to [ION].
    5. Click OK to update the owner of the database.
    6. Click OK to close the Database Properties dialog.
  9. Restart all ION services.
Restoring a specific database

Complete the following to restore a specific database:

  1. Repeat steps 1 through 3 from Restoring the latest database above.
  2. Under Source, select Device and click Browse to open the Select backup devices dialog.
  3. Select File in Backup media type list if it is not already specified and then click Add to open the Locate Backup File dialog.
  4. Navigate to and select the backup file you want to restore and click OK.
  5. Verify that the file referenced in the Specify Backup dialog is the one you selected and click OK to return to the Restore Database dialog.
  6. Under Select the backup sets to restore, select the checkbox in the Restore column for the database you are restoring.
  7. Click Options in the Select a page pane on the left.
  8. On the Options page:
    • Under Restore options, select Overwrite the existing database (WITH REPLACE).

    • Under Recovery state, select RESTORE WITH RECOVERY from the dropdown list.

      RESTORE WITH RECOVERY is described as Leave the database ready to use by rolling back uncommitted transactions. Additional Transaction logs cannot be restored.

  9. Click OK to begin the restore operation.

    A message indicates that the database has been restored successfully. If the restore operation is not successful, the database reverts to its original state.

    NOTE: After you restore the database, you need to assign its ownership to the ION user as follows:

    1. In SQL Server Management Studio, right-click the restored database and click Properties in the menu to open the Database Properties dialog.
    2. Click Files under Select a page.
    3. Click the button on the right of the Owner field to open the Select Database Owner dialog.

    4. Type ION in the field labeled Enter the object names to select and click Check Names.

      The format of your entry changes to [ION].

    5. Click OK to update the owner of the database.
    6. Click OK to close the Database Properties dialog.
  10. Restart all ION services.