I'm using SQL Server 7.0 on a server that doesn't have performance issues or tons of traffic. I have a fairly large database (~100 Megs), and I need to delete a pull subscription. When I do this, however, the database server hangs, and I have to restart the MSSQL and SQL Server Agent services...
Now that I've put the initial snapshot onto the subscriber, I'm not sure why the snapshot agent would need to run on a schedule afterward. On the other hand, SQL Server 7.0 seems to set this up by default. Was this just configured when the sys admin set it up possibly? Or is there a good reason...
I'm running 2 SQL Server 7.0 servers doing Merge Replication. The idea really is to have mirrored servers in case one crashes :)
The "live" server is currently the subscriber. The "backup" server is running as publisher and distributor, basically because we wanted it to be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.