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 |
|
krajdba
Starting Member
43 Posts |
 Posted - 2008-03-20 : 11:39:26
|
| Hi How to fix Subtscriber data which is out of sync with the publisher data. Not all the data but only the diffrerence and also fix the log reader agent issues.Please help urgent.ThanksRaj. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-20 : 11:45:54
|
| Check Replication monitor.Restart log reader agent. Restart replication jobs on Subscriber. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-20 : 23:19:31
|
| If doesn't work, restart snapshot. |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-03-31 : 09:21:05
|
| I think I have the same problem with publisher and subscriber out of sync.. what does snapshot do? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 09:49:48
|
| Snapshot agent takes whole snapshot of your tables/database at point in time |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-03-31 : 13:11:47
|
| Can Snapshot be run at any time to re-sync between publisher and subscriber? is there a particluar procedure that you have to follow? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 15:06:35
|
| No,It should be run only once while configuring replication. But while adding articles and some issues with replication,you have to run it again |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-03-31 : 15:56:03
|
| so if you can't run a snapshot.. how do you resync if your databases get out of sync? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 16:05:52
|
| I am just giving you scenerio when actually you should. Start snapshot agent and what it gives. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-31 : 23:17:34
|
| Yes you can run snapshot to resync dbs, have to create new snapshot when run it. |
|
|
|
|
|
|
Subscriber data out of Sync.