THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Message Details

Product Name SQL Server
Event ID -2147199431
Event Source MSSQLServer
Symbolic Name
Message Text The Merge Agent was unable to generate a partitioned snapshot for this subscription; either the Snapshot Agent failed to run or the location for the partitioned snapshot could not be accessed. The subscription will be initialized using a standard snapshot.


This error indicates one of the following problems occurred:

  • A failure while running a snapshot job through the snapshot control.

  • A failure while obtaining the location for the dynamic snapshot job.

User Action

Review the snapshot history tables on the distribution database, or use SQL Server Profiler to debug the snapshot process.