› Output Manager › Server and database administration › Backing up and restoring the Output Manager database › Restore a backup

Restore a backup

Complete the steps in this procedure to restore a database using SQL Server Management Studio.

The database version must match the product version. Under some circumstances a previous version of the database can be restored and then upgraded using the database creation utility. Typically, however, the most recent backup will result in minimal data loss. Backups of older data from previous versions will represent result in the greatest data loss.

  1. Stop all Output Manager services that use the database.
  2. Open SQL Server Management Studio to restore the database from a backup file.
  3. Right-click the Databases folder and click Restore Database.
  4. In the To database box, select the database you want to restore or type the name in the box.
  5. Select From device and browse to the desired backup file.
    You will normally want to select the latest backup file unless there is a configuration problem you are trying to avoid.
    The file will show in the Select the backup sets to restore grid.
  6. In the grid, select the check box next to the database you want to restore.
  7. Click OK.
    SQL Server Management Studio will show success or failure.
  8. After the database is restored successfully, restart the Output Manager services.
Any configuration or activity that occurred after the backup was performed will be lost. The documents and their respective states will only be current as of the backup date and time.