Details
Product:SQL Server
Event ID:21076
Source:MSSQLServer
Version:10.0
Component:SQL Server Database Engine
Message:The initial snapshot for article '%s' is not yet available.
   
Explanation

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.

   
User Action

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).

   
   
Version:9.0
Component:SQL Server Database Engine
Message:The initial snapshot for article '%s' is not yet available.
   
Explanation

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.

   
User Action

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).

   
   
Version:8.0
Component:SQL Engine
Message:The initial snapshot for article '%s' is not yet available.
   
Explanation
You have created or reinitialized a transactional subscription that was created with the Yes, initialize the schema and data option, and you started the Distribution Agent before you started the Snapshot Agent or before the Snapshot Agent had completed. You will only see this error if there is only one article associated with the Distribution Agent. If there are multiple articles associated with the the Distribution Agent, you may see the error 21075, "The initial snapshot for publication '%s' is not yet available."
   
User Action
If the associated Snapshot Agent has not been started since the subscription was created or if it has not been started since the last time you choose to reinitialize the subscription, you will need to start the Snapshot Agent and let it complete before starting the Distribution Agent.

If the Snapshot Agent does not complete, check the Snapshot Agent history for errors and address them. If necessary, you can add a log to the Snapshot Agent to see if more details can be returned for any errors. For more information about how to enable replication agent logging, see the Microsoft Knowledge Base article 312292.