Recovering lost data from a restored backup
I have a live db that had a page tear and I had to repair with data loss. I don't have any transaction logs to work with. What I do have is a backup from the day before which I have restored on a dev server. I want to bring over the missing data that is now gone as a result of the page tear. I am assuming there is some data on the restored backup that I can recover. Can I use SQL Data Compare to do this? The live db will have more records than the backup and I don't want to lose that data. If I were to synchronize these databases, would it accomplish what I am trying to do?
0 · Share on Twitter