Enterprise Configuration Configuring P2000 Central Server
24-10515-21 Rev. – 2-25
This document contains confidential and proprietary information of Johnson Controls, Inc.
© 2010 Johnson Controls, Inc.
10. Exit Query Analyzer without saving the script file. Keep the Microsoft SQL
Server Management Studio window open.
SNAPSHOTS
Once the publications are created, you need to generate the snapshots for each
publication. The snapshots contain the initial data from the Publisher, schema
(database structure) information, and initialization parameters for tables with
identity columns.
NOTE
It is recommended that you run each snapshot separately. If multiple
snapshots are run simultaneously, deadlocks can occur and the distribution
control tables may get corrupted.
To run a snapshot:
1. In the Microsoft SQL Server Managemen
t Studio window, expand the
navigation tree and go to Replication>Local Publications folder.
2. Right-click on a publication and select View Snapshot Agent Status.
3. In the select View Snapshot Agent Status window click St
art.