General discussion

Locked

SQL Replication error

By mrushing ·
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

This conversation is currently closed to new comments.

21 total posts (Page 1 of 3)   01 | 02 | 03   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Replication error

by paultalb In reply to SQL Replication error

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!

Collapse -

SQL Replication error

by mrushing In reply to SQL Replication error

Poster rated this answer

Collapse -

SQL Replication error

by Otura In reply to SQL Replication error

Mmmmm.... look around DB consistency checker...

Collapse -

SQL Replication error

by mrushing In reply to SQL Replication error

Poster rated this answer

Collapse -

SQL Replication error

by msullivan In reply to SQL Replication error

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

Collapse -

SQL Replication error

by mrushing In reply to SQL Replication error

Poster rated this answer

Collapse -

SQL Replication error

by ke4vtw In reply to SQL Replication error

Forgot my email address:

ke4vtwwork@yahoo.com

Collapse -

SQL Replication error

by mrushing In reply to SQL Replication error

Poster rated this answer

Collapse -

SQL Replication error

by Otura In reply to SQL Replication error

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...

Collapse -

SQL Replication error

by mrushing In reply to SQL Replication error

Poster rated this answer

Back to Windows Forum
21 total posts (Page 1 of 3)   01 | 02 | 03   Next

Related Discussions

Related Forums