I have a publication on SQL Server 2008 Standard Edition using merge replication. When I attempt to generate the initial snapshot, the snapshot agent appears to hang on the step "Setting up the publication for filtered articles." I
get a long (over 4 hour) series of messages: "The process is running and is waiting for a response from the server." I know something is happening server-side, as SQL Server and the snapshot agent use a lot of memory and max out one core's
This has me confused as the publication is not doing any filtering.
Even more confusing: I backed up the database and restored it onto my development-test system. I created the snapshot there, and it took under 10 minutes every time.
Any suggestions for investigating and resolving this?
View Complete Post