April 6, 2016 at 12:25 am
Hi All,
One of my report server databases are corrupted. Please someone provide me the fix for the same.
April 6, 2016 at 1:01 am
Im no corruption expert but to help others please give output for
DBCC CheckDB ('ReportServer') WITH NO_INFOMSGS, ALL_ERRORMSGS
April 6, 2016 at 1:03 am
I am getting below error message
Msg 823, Level 24, State 2, Line 1
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000012000 in file 'J:\SQLData\ReportServer.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
April 6, 2016 at 2:51 am
Is the file there?
Can it be accessed by the SQL Server service account?
Is it read/write?
-- Gianluca Sartori
April 6, 2016 at 2:54 am
Yes files are available.
Now I have fixed the issue by detach and attaching the MDF from latest available disk backups
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply