Event Id21386
SourceMSSQLServer
DescriptionSchema change failed on publication '%s'. Possibly due to active snapshot or other schema change activity.
Event InformationAccording to Microsoft

Cause:
For certain replication operations, such as adding or dropping a column, the replication process must ensure that no snapshot process is performing work on the specified publication. This message indicates that the attempt to get an application lock via sp_getapplock on the specified publication for the exclusive operation failed because either a Snapshot Agent is working on the specified publication or another schema change is being performed from another connection.
Resolution:
Before executing the replication process, stop all Snapshot Agents for the specified publication. Verify that no one else is currently executing sp_repladdcolumn or sp_repldropcolumn for the specified publication.
Reference LinksEvent Id:21386 of Source Id:MSSQLServer


  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