Checking whether replication is running
To obtain a report on the replication status of the database, you should first open the publication database.
The following messages are reported for the current database:
Message | Description |
---|---|
Publication is OK | When run in the publication database, this indicates that the Publisher is configured for replication. |
Publication not found |
Replication is not running at the Publisher. If you run this report while in a subscription database then information on the Publisher, or whether replication is running, is not available. |
The publication is invalid because it allows anonymous subscriptions |
When run in the publication database, this tells you that replication is incorrectly configured
in SQL Server. Contact your SQL Server administrator.
Note: You will not be able to review and
resolve any conflicts until this problem is fixed. |
<server>\<instance>:<SQL Server database name> | When run in the publication database, this shows you the names of the subscriptions to this publication database. |
No subscriptions | When run in the publication database, this indicates that the subscriber sites are not yet configured for replication. |
Note: The Status report does not report any problems with the communication links between
Subscribers and Publishers, or any problems with the replicated security connection file or audit
log.