Hi,
I've got a merge replication set up with an SQL 2005 publisher/distributer and a dozen or so SQL 2000 clients. It's been running fine for a little while, but after upgrading to sp2 this morning I can't create a new snapshot. I can start the snapshot agent, but it hangs with this in the status box:
From what I've found on the web, this is usually from a long running query in the background or interference from scheduled tasks. I disabled all the schedules and rebooted but still have the same problem.
I've created a bunch of snapshots while rolling this out a few weeks ago so I know it was working. Has anybody else run into this?
Thanks
Pat
I've got a merge replication set up with an SQL 2005 publisher/distributer and a dozen or so SQL 2000 clients. It's been running fine for a little while, but after upgrading to sp2 this morning I can't create a new snapshot. I can start the snapshot agent, but it hangs with this in the status box:
Code:
"0% The process is running and is waiting for a response from the server".From what I've found on the web, this is usually from a long running query in the background or interference from scheduled tasks. I disabled all the schedules and rebooted but still have the same problem.
I've created a bunch of snapshots while rolling this out a few weeks ago so I know it was working. Has anybody else run into this?
Thanks
Pat
