If a subscription has not dematerialized, follow the general procedure in this section. See Chapter 5, “Subscription Problems”, for specific instructions.
Procedure if subscription has not dematerialized
Log in to the destination Replication Server and check subscription status using check subscription. Do the same for the primary Replication Server. check subscription returns information that diagnoses the problem. The potential problems include:
Other subscriptions to the same replication definition and replicate database have not yet processed
No connection to the primary Replication Server because of an incorrect login
Primary Replication Server down or out of stable queues
Stable Queue Manager (SQM), Stable Queue Transaction interface (SQT), and Distributor (DIST) threads down
Primary data server down, incorrect login, out of stable queues, or rows selected with holdlock
RepAgent problem
Route problem
Destination Replication Server DSI problem
Incorrect user privileges on destination database
If some columns are not being dematerialized:
Check replication status of text, unitext, and image columns.
Verify that the replication definition is correctly defined.
Fix the problem.
When you think you have solved the problem, run the replication system. If subscriptions are still not being dematerialized correctly:
Analyze errors (see “Analyzing error logs”), or
Complete any of this section’s procedures that you skipped.