THe mistry of disappearing data rows..
On a monday morning, the last thing you would want is someone yelling abt some lost data...
Ah..may be it got deleted...may be it never got inserted...But the process has not been modified since 2004...so, why now !! what changed !!
Well as it turns out, it was the case of replication gone haywire...I had the database set for merge replication with another machine with the Live machine having 100% priority in case of a conflict so that the backup machine would only get the changes and not the other way round in case of any changes...
And guess what happened...the SQL Server conviniently decided that if the row is in a conflict its a good idea to delete it from my live machine...So, the rows of data started disappearing...
Not a good thing !!!!
Anyhu...now the database is set for snapshot replication..more time consuming but definately unidirectional...
No comments:
Post a Comment