Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2007-12-07 : 14:52:55
|
| Hi everyone,The full backup was corrupt, is there a way to restore a partial database backup as a current version??thankstony |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-07 : 14:55:49
|
| No. In order to restore a differential, you must first restore the full backup.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-12-07 : 15:17:32
|
| crud....may i make a backup of the current data, and restore an older diff over top of it? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-07 : 15:25:41
|
| No, that's not how backups work. Please see BOL for how differentials work.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-12-07 : 15:31:47
|
| this really sucks....the verify option is/was selected on the backup and it is still corrupt AUGH!now the database cannot be restored to a previous date.this really blows |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-07 : 15:58:21
|
| The verify option doesn't do what you think. The only way to truly verify if a backup is restorable is to restore it. That's why you should be doing this regularly in a test environment to ensure you can recover data. I'd suggest opening a case with MS immediately to see if they can fix your corrupt backup file. Spending the money for them to help you on this is better than losing everything.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-07 : 23:06:51
|
| Typically it's due to hardware issues.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-12-10 : 09:15:11
|
| Update!!!!Yes, it was a hardware issue. Come to find out, there is/was a weak sector on one of the hard drives in the raid.It was good enough not to flag in the raid, but it was soft enough to not work.Long story short - spend the cash on better drives!!!!thanks for you help!!take caretony |
|
|
|
|
|
|
Restore a differential backup as full