October 28, 2010 at 3:49 pm
I have done snapshot replication setup which is running smoothly for some time but suddenly started facing some issues. Around 250GB data at publisher and replication is not happening. I tried of reinitializing which didn't work. And I try to remove the existing setup and reconfigure but facing errors/issues and not able to configure the same.
Can anybody help me how to debug this issue?
How to fix this kind of problems in replication.
Thank you.
Regards,
October 29, 2010 at 5:58 am
vinsat (10/28/2010)
but facing errors/issues and not able to configure the same.Can anybody help me how to debug this issue?
How to fix this kind of problems in replication.
Regards,
wat is the error ?? brief the issue.......
October 29, 2010 at 9:11 am
250GB of Data and you chose Snapshot replication? For a DB if that size, Snapshot is not the way to go. You will encounter quite a few issues.
1. The Snapshot can cause Dead lock and heavy blocking
2. Run out of space in the snapshot folder
3. Timeouts. (This is more likely)
It would have been better to just restore the back up.
Just my 2 cents
-Roy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply