Snap-Shot Replication - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Snap-Shot Replication

Author

Topic

mattl
Starting Member

5 Posts

Posted - 2005-03-04 : 07:17:30

I hope someone can help me.
I have two SQL 2000 sp3a servers one at my ISP and one on my internal network. All relevant ports (1433) are open on the firewalls between these servers.
I have setup snap-shot replication on four dbs on a schedule to run nightly. Three of the dbs complete successfully but the fourth sits there for an hour or so then takes the CPU to the max and eats mem. It sits like this until you endtask the distrib process. There are no errors in the eventlogs and nothing in the replication Alerts.
I have setup the same job on other customers SQL servers with the same dbs and schemas for it to work fine

Any ideas on this

Thanks

Matt

mattl
Starting Member

5 Posts

Posted - 2005-03-04 : 07:30:08

It seems to be getting stuck one one table which contains binary documents?
Is there anything I can run on this table to see a potential problem? I have run the 'Replication Conflicts' utility but it says that everything is fine?

mattl
Starting Member

5 Posts

Posted - 2005-03-18 : 05:39:40

Just putting a reply on this to take it to the top of the list and hope that there is someone out there who can answer this for me.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources