Restoring Backup db_ControlManager Using SQL Server Management Studio

Use the SQL Server Management Studio to restore the backup Control Manager database.

  1. Stop Control Manager.
  2. Click Start > Programs > Administrative Tools > Services to open the Services screen.
  3. Right-click <Control Manager service>, and then click Stop.
  4. Click Programs > Microsoft SQL Server 2005 > SQL Server Management Studio to access the SQL Server Management Studio.
  5. On the console, click Microsoft SQL Server 2005 > SQL server group > {SQL server} > Databases.

    {SQL server} is the SQL Server host name.

  6. Right-click db_ControlManager > All tasks > Restore Database….
  7. On the Restore database screen, select the database to restore.
  8. Click OK to start the restoration process.
  9. Click OK when the message "Restore of database '{Control Manager database"}' completed successfully." appears.
  10. Click Start > Programs > Administrative Tools > Services to open the Services screen.
  11. Right-click <Control Manager service>, and then click Restart.
  12. Start Control Manager.