Milestone Central 3.7 - Manual (Page 72)

Milestone XProtect 3.7; Administrator’s Manual
databases are some easy-to-use backup and restoration features. Download and install the
tool on your existing Management Server. Other backup tools than SQL Server
Management Studio Express will also work, but this document describes use of SQL Server
Management Studio Express.
Backing Up the Database
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 backing up 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
(in the example illustration in the following, the
server is called MM01232), and connect with the
user account under which the database was created.
Tip: You do not have to type the name of the SQL
server: If you click inside the Server name field and
select <Browse for more...>, you can select the required SQL Server from a list instead.
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. We are primarily
interested in the VIDEOOS_CENTRAL database.
3. Right-click the VIDEOOS_CENTRAL database, and select Tasks > Back Up...
4. On the Back Up Database dialog’s General page, do the following:
• Under Source: Verify that the selected database is VIDEOOS_CENTRAL and that the
backup type is Full.
• Under Destination: A destination path for the backup is automatically suggested.
Verify that the path is satisfactory. If not, remove the suggested path, and add
another path of your choice.
5. On the Back Up Database dialog’s Options page, do the following:
• Under Reliability: Select Verify backup when finished and Perform checksum before
writing to media.
6. When ready, click OK to begin the backup. When backup is finished, you will see a
confirmation. When finished, exit Microsoft SQL Server Management Studio Express.
7. 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.
www.milestonesys.com Page 72 Backing Up & Restoring the …