SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Restore a differential backup as full		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pithhelmet
Posting Yak Master

183 Posts
Posted - 12/07/2007 :  14:52:55  Show Profile  Reply with Quote
Hi everyone,

The full backup was corrupt, is there a way to restore a partial database backup as a current version??

thanks
tony

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 12/07/2007 :  14:55:49  Show Profile  Visit tkizer's Homepage  Reply with Quote
No. In order to restore a differential, you must first restore the full backup.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

pithhelmet
Posting Yak Master

183 Posts
Posted - 12/07/2007 :  15:17:32  Show Profile  Reply with Quote
crud....

may i make a backup of the current data, and restore an older diff over top of it?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 12/07/2007 :  15:25:41  Show Profile  Visit tkizer's Homepage  Reply with Quote
No, that's not how backups work. Please see BOL for how differentials work.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

pithhelmet
Posting Yak Master

183 Posts
Posted - 12/07/2007 :  15:31:47  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 12/07/2007 :  15:58:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

funketekun
Constraint Violating Yak Guru

Australia
491 Posts
Posted - 12/07/2007 :  22:53:12  Show Profile  Visit funketekun's Homepage  Reply with Quote
I wonder how the backup file got corrupted.




http://www.sqlserverstudy.com
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 12/07/2007 :  23:06:51  Show Profile  Visit tkizer's Homepage  Reply with Quote
Typically it's due to hardware issues.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

pithhelmet
Posting Yak Master

183 Posts
Posted - 12/10/2007 :  09:15:11  Show Profile  Reply with Quote
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 care
tony
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000