| Event Id | 21386 |
| Source | MSSQLServer |
| Description | Schema change failed on publication '%s'. Possibly due to active snapshot or other schema change activity. |
| Event Information | According 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 Links | Event Id:21386 of Source Id:MSSQLServer |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.