Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

MSSQL_ENG021076

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

Event ID

21076

Event Source

MSSQLSERVER

Component

SQL Server Database Engine

Symbolic Name

Message Text

The initial snapshot for article '%s' is not yet available.

Error MSSQL_ENG021076 can be raised if the Distribution Agent is started before the Snapshot Agent has finished generating the snapshot. This error is raised only if the publication contains a single article. If the publication contains more than one article, MSSQL_ENG021075 is raised instead. For more information, see MSSQL_ENG021075.

If the Snapshot Agent for the publication has not been started since the subscription was created, or if it has not been started since the last time you chose to reinitialize the subscription, start the Snapshot Agent and let it complete before starting the Distribution Agent. For more information, see Creating and Applying the Snapshot.

If the Snapshot Agent does not complete, check the Snapshot Agent history for errors and address them. For information about viewing agent status and error details in Replication Monitor, see How to: View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor).

If the error continues to occur, increase the logging of the agent and specify an output file for the log. Depending on the context of the error, this could provide the steps leading up to the error and/or additional error messages. For more information, see Replication Agents (Troubleshooting).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.