Discussion Locked

SQL Replication error

0 helpful
21 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Just set up a merge replication from SQL Enterprise ManagerSQL7 on NT4 and keep getting an error with the initial snapshot application saying the timeout has expired while trying to prepare one of the tables for replication. Retries 10 times and quits. It gets through one table and then always dies after waiting 10 minutes on the second. I am very much a beginner with SQL. Thanks in advance. If you need more info for your reply, e-mail mrushing@colemanresearch.com

21 replies

by paultalb

I think service pack 2 takes care of some of the replication issues. Make sure you at least have SP1, we have been using SP2 without issue for a month.
Good Luck!

by msullivan

Your problem seems to be related to a specific table.

Here are a few suggestions.

Check permissions for the table in question. The distributor agent account must be able to access the table. As a general rule, use the same NT account for ALL SQL Server services on ALL computers.

Make sure you have enough room on the distributor to replicate the table. A large table being distributed by a resource challenged distributor will fail when it runs out of room.

Snapshots script thedatabase and BCP the data. Try scripting the table manually and see if the script works. If not, run DBCC as suggested earlier. If you cannot script the database out and then run the script on another box, snapshot replication will not work.

Hope this helps you.
Mike

by otura

Be sure to be using an account with administrative rights for the domain in which both servers reside. If you're using a local system account or an account without domain administrator rights you'll be having errors...

I hope this helps you...

by kalufos

Check Your Tables Structure.
Are you replicating all the colums or part of the table?
We have a similar problem a few months ago and found that SQL 7 had a prblem when you replicate a numeric filed followed by a text field, This only happens whenyou are replicating a part of the table

by sonnysan

Go to event viewer. Note subject and error #. If there is nothing under subject, find the subject in the details pane. Then aquire a technet cd. Type in in search. The results will go into great detail about your problem. It's the best info. If it's not in technet, the only other solution is to call Microsoft. Technet will solve 98% of your error codes. Since Microsoft charges 1K/hour, technet is the better solution. Hope that helps.

This discussion is closed to new replies.