May 20, 2006 at 7:28 am
I am trying to replicate a 100GB database via transactional replication to another server for reporting purposes. This has worked successfully in a test before, though I deleted the publication after the test. Now, I can create the snapshot successfully, and the distribution agent applies the snapshot initially, but something is happening between that snapshot application and the creation of indexes on the subscriber -- I see the command "IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION". And that's just what it does. I have tried different subscribers and removing and re-adding replication from scratch (just in case it was a corrupt distribution database) but I keep getting the same results. I plan on profiling this later, but does anyone know why such a scenario might happen, or things I can check out? I tried to replicate a small subset and it went fine.
May 23, 2006 at 8:00 am
This was removed by the editor as SPAM
May 25, 2006 at 8:06 am
Jeff - see the post Manual Syncronization and Maintain Consistency in this topic on this board. Likely what you'll need to do is apply the initial snapshot manually using backup / restore (or another means) and then manually syncronize the data.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=282135
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy