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
Our community of experts have been thoroughly vetted for their expertise and industry experience.