troubleshooting Question

SQL Server Corrupt database issue

Avatar of skbohler
skbohler asked on
Microsoft SQL Server
24 Comments2 Solutions1268 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
skbohler

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 24 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros