MSSQL: Data recovery or force restore?
Posted on 2006-05-30
I need to restore my sql server from backup. Normally no problem, however my last full backup filled up the disk before it finished thus that backup is no good. The subsequent differentials ran OK. However I'm in a situation where the database blewup and I need to restore.
Week 1 - successful full
week 1 - successful differentials
week 2 - failed full
week 2 - successful differentials
end of week 2 - database crash - need to restore.
I see to not be able to apply the successful differentials from week 2 to the full from week 1. I suspect it thinks the full from week2 was successful and differentials are from the point? "Cannot apply the backup on device '<file>' to the database '<database>'" is the message I get.
At this point we're not concerned about consistency, we just want to get raw data back to re-insert into a new database. Is there a way? Just to see raw tables, csv, tab delimited or anything would be fine. Or better yet, apply the week2 differential to the week1 full. Am I just SOL?