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.