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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-11-24 : 00:05:38
|
| Dear All,is there any maintenance activity for replication to make it 100% sync? any weekly or monthly maintenance? please let me know...I've observed that my replication is getting stopped on intervals like every two months....there are several things for those failures. (one reason is the repldata folder sharing is failed...i don't know the exact reason how that was happened). please let me know are there any maintenance activities.....thanks in advanceArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-24 : 07:17:18
|
| See: http://msdn.microsoft.com/en-us/library/ms151749(SQL.90).aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-24 : 13:10:38
|
quote:
Originally posted by darkdusky
See: http://msdn.microsoft.com/en-us/library/ms151749(SQL.90).aspx
Why Merge replication has to do with this? sunsanvin,One thing I have noticed with Snapshot folder is that you shouldn't give all permission to everyone .Restrict the snapshot folder. We have MOM tool to watch Replication and mail to DBA. You can use Notification in Replication jobs to notify DBA if it fails. |
|
|
|
|
|
|
replication maintainance process....