We help IT Professionals succeed at work.
Get Started
SQL Server Corrupt database issue
Hello,
I seem to have a corrupt production database (SQL Server 2008 Standard edition)
When trying to connect to it, get the error:
"SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:0) in database ID 13 at offset 0000000000000000 in file ..."
I can't even run DBCC Checkdb on it without getting an error that it can't connect to it.
I do have a backup from the previous day.
A) Do I have to try and restore from the previous backup (and lose a day of data)? Or Is there a way to try and repair?
B) If I need to restore, what steps to restore to the previous backup? The "restore" menu option for this offline database is grayed out.
Thanks!
Steve
I seem to have a corrupt production database (SQL Server 2008 Standard edition)
When trying to connect to it, get the error:
"SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:0) in database ID 13 at offset 0000000000000000 in file ..."
I can't even run DBCC Checkdb on it without getting an error that it can't connect to it.
I do have a backup from the previous day.
A) Do I have to try and restore from the previous backup (and lose a day of data)? Or Is there a way to try and repair?
B) If I need to restore, what steps to restore to the previous backup? The "restore" menu option for this offline database is grayed out.
Thanks!
Steve
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE