• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

MSSQL: Data recovery or force restore?

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.  

My situations.
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?
0
hr_sea
Asked:
hr_sea
  • 2
  • 2
1 Solution
 
ptjcbCommented:
The differentials from week 2 are based on the week 2 full backup. You will be able to restore week 1 backups. The week 2 backups are useless and cannot be restored.
0
 
imran_fastCommented:
Database crashed what is it in suspect state or what tell us may be there is way to get it back online.

if you are dependend on backup than the only way is what ptjcb suggested.
0
 
hr_seaAuthor Commented:

(disclaimer:  I'm not a sql expert so my terminology may be wrong)

An update statement which changed all the values in one field (column) was executed.  Our "dba" was not using transactional updates (?) so could not roll back the action.

So, I guess what I'm seeing is that any differential after any sort of incomplete full is worthless.
0
 
ptjcbCommented:
Yes. A differential is based on the changes of the last full backup (whether or not it was successful) - because your full backup failed, then the differentials based on it are useless.

Your terminology is fine - it sounds as if your dba ran an update statement without the WHERE clause. He is not the first one to do that or the last.
0
 
hr_seaAuthor Commented:


Yes, our dba ran and update without the WHERE.  I know it happens!  Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now