Event ID - 21075

Event Id21075
SourceMSSQLServer
DescriptionThe initial snapshot for publication %s is not yet available.
Event InformationCAUSE:
You will see the above error under the following circumstances.
For merge replication:

You will see this error when you have created or reinitialized a merge subscription and you started the Merge Agent before you started the Snapshot Agent or before the Snapshot Agent had completed.
For transactional replication:

You have created or reinitialized a transactional subscription which 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 get this error if the subscription is the only subscription associated with the Distribution Agent or if all subscriptions associated with the Distribution Agent are in the above state. As soon as any one of the subscriptions associated with the Distribution Agent has an available snapshot, the agent history message will instead say either, "No replicated transactions are available," or it will report the number of transactions and commands delivered for other subscriptions associated with this agent. If there is only one article in a transactional publication and that article meets the criteria described above, the error will instead be 21076, "The initial snapshot for article %s is not yet available."

RESOLUTION:
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 chose to reinitialize the subscription, you will need to start the Snapshot Agent and let it complete before starting the Merge Agent or 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 that you see.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 21075

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.