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.
| Author |
Topic |
|
surefooted
Posting Yak Master
188 Posts |
 Posted - 2009-03-24 : 11:16:47
|
My distributor is a 2008 server and the publisher is 2000 sp3a as well as it's subscriber. The snapshot runs fine. It tries to apply the snapshot and just starts what seems to be a continual loop. It never finishes. Please help.-JonShould still be a "Starting Member"  . |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2009-03-24 : 13:23:16
|
| I have found that it is erroring while creating the primary key if that helps any.-JonShould still be a "Starting Member" . |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-24 : 14:07:12
|
| what is the error message?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2009-03-27 : 12:29:06
|
| It isn't giving an error message. It just keeps looping through it's process. But only for a few tables and not all.Applied script 'table.pre'Applied script 'table.sch'Bulk copying data into table 'table'Bulk copied data into table 'table' (1490583 rows)Creating Primary Key index on table 'table'Delivered snapshot from the 'unc\server\blah'Applied script 'table.pre'Applied script 'table.sch'Bulk copying data into table 'table'Bulk copied data into table 'table' (1490583 rows)Creating Primary Key index on table 'table'Delivered snapshot from the 'unc\server\blah'Then it repeats again. In a continuous loop and never stops or commits the table.-JonShould still be a "Starting Member" . |
|
|
|
|
|
|
Replication won't apply the transactional snapshot