May 8, 2008 at 10:03 am
Hi All,
After executing DBCC checkcatalog ('msdb') got following error message.
Server: Msg 823, Level 24, State 2, Line 1
I/O error (bad page ID) detected during read at offset 0x000000006b6000 in file 'e:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf'.
DBCC results for 'msdb'.
Connection Broken
How can I resolve this issue. Any response will be appriciable.
May 8, 2008 at 10:12 am
What's the most recent backup you have for MSDB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 8, 2008 at 10:21 am
Check the location of msdbdata.mdf file?
May 8, 2008 at 10:34 am
Thanks for response,
I've checked the location of msdb database it seems ok. Is there any other way without restoration of msdb database.
Regards,
austin
May 8, 2008 at 10:41 am
Do you not have a backup?
There is a way, but it will cause data loss. No idea how much, or from which table.
Please run the following...
DBCC CHECKDB('msdb') WITH NO_INFOMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply