Home Forums Database Design Disaster Recovery Copy off original data, even if it is corrupt - before restoring backups? RE: Copy off original data, even if it is corrupt - before restoring backups?
SkyBox
SSCarpal Tunnel
Points: 4288
More actions
May 5, 2011 at 7:50 pm
#1320763
After putting some thought into it. I can create a test db, restore it from my full backup, diff, and transaction log backups. Once I validate the data/restore, I can drop the corrupt production database. Then rename the test db to production.