Event Id21075
SourceMSSQL_ENG
DescriptionThe initial snapshot for publication %s is not yet available
Event InformationAccording to Microsoft

Cause:

Error MSSQL_ENG021075 is raised if the Distribution Agent or Merge Agent is started before the Snapshot Agent has finished generating the snapshot.

Resolution:

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 or Merge 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
Reference LinksEvent ID 21075 of Source MSSQL_ENG


  Did this information help you to resolve the problem?
  Yes: My problem was resolved.
  No: The information was not helpful / Partially helpful.
  Comments:

Captcha  Refresh