Milestone Central 3.7 - Manual (Page 73)

Milestone XProtect 3.7; Administrator’s Manual
www.milestonesys.com Page 73 Backing Up & Restoring the …
Restoring the Database
Luckily, most users never need to restore their backed-up XProtect Central database, but if you
ever have the need, use the following process:
1. Stop the Central Server service to prevent changes to the database being made during the
backup process. Note that XProtect Central basically will not work while the Central Server
service is stopped; it is thus important to remember to start the service again once you
have finished restoring the database.
2. Open Microsoft SQL Server Management Studio Express from Windows’ Start menu,
typically by selecting All Programs > Microsoft SQL Server 2005 > SQL Server Management
Studio Express. When you open the tool, you are prompted to connect to a server. Specify
the name of the required SQL Server, and connect.
3. Once connected, you will see a tree structure in the Object Explorer in the left part of the
window. Expand the SQL Server item, then the Databases item.
4. Right-click the VIDEOOS_CENTRAL database, and select Tasks > Restore > Database...
5. The Restore Database dialog’s General page, do the following: Under Source for restore,
select From device, and click the
button to the right of the field.
6. In the Specify Backup dialog’s Backup media list, make sure that File is selected. Then click
the Add button.
7. In the Locate Backup File dialog, locate and select your backup file
VIDEOOS_CENTRAL.bak. Then click OK.
8. Back in the Specify Backup dialog, the path to your backup file is now listed. Click OK.
9. Back on the Restore Database dialog’s General page, your backup is now listed under
Select the backup sets to restore. Make sure you select the backup by selecting the check
box in the Restore column.
10. Now go to the Restore Database dialog’s Options page, and select Overwrite the existing
database. Leave the other options as they are.
11. When ready, click OK to begin the restoration. When the restoration is finished, you will
see a confirmation. When finished, exit Microsoft SQL Server Management Studio Express.
Tip: If instead you get an error message telling you that the database is in use, try exiting
Microsoft SQL Server Management Studio Express completely, then repeat steps 1-10.
12. During the backup process, the Central Server service was stopped to prevent database
changes being made until you were done. Remember to start the Central Server service
again.