Back up the database – Milestone XProtect Transact User Manual
Page 55
Milestone XProtect
®
Transact
Administrator's Guide
www.milestonesys.com
55
Back up and restore the Transact
Database
Back up the database
Stop the XProtect Transact Server service to prevent changes to the database being made during the
backup process. Note that XProtect Transact will not work while the XProtect Transact Server service
is stopped. It is important that you remember to start the service again once you have finished backing
up the database.
1. Open Microsoft SQL Server Management Studio Express from the Windows Start menu.
2. When you open the tool, you are prompted to connect to a server.
3. 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 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_XProtect Transact database.
1. Right-click the VIDEOOS_XProtect Transact database, and select Tasks > Back Up...
2. On the Back Up Database
dialog’s General page, do the following:
o
Under Source: Verify that the selected database is VIDEOOS_XProtect Transact and
that the backup type is Full.
o
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.
3. On the Back Up Database
dialog’s Options page, do the following:
o
Under Reliability: Select Verify backup when finished and Perform checksum before
writing to media.
4. When ready, click OK to begin the backup. When backup is finished, you see a confirmation.
Eit Microsoft SQL Server Management Studio Express after this.
5. During the backup process, the XProtect Transact Server service was stopped to prevent
database changes being made until you were done. Remember to start the XProtect Transact
Server service again.