January 5, 2011 at 4:19 am
Hi dear freinds,
Please help me. Today i got an error message while running dbcc checkdb on one of my database.
Error message:
Msg 8928, Level 16, State 1, Line 9
Object ID 2073058421, index ID 0, partition ID 72057594038321152, alloc unit ID 72057594042318848 (type In-row data): Page (1:143) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 9
Table error: Object ID 2073058421, index ID 0, partition ID 72057594038321152, alloc unit ID 72057594042318848 (type In-row data), page (1:143). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.
How i can solve this problem? pls help me out.
Thanks in advance.
M.I.
________________________________________
M.I.
[font="Times New Roman"]
January 5, 2011 at 5:29 am
You have database corruption, at least one page is damaged and not readable.
That's not the full output of checkDB, please run the following and post the full and complete output.
DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS
Do you have a clean backup of this database? (One without the corruption)? What recovery model is the database running in?
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
January 5, 2011 at 5:47 am
Yep your DB has spat it.
As Gila said: have you got backups? (good ones). Because you'll be looking to restore it if possible.
also:
- what is the role of DB? Dev/Test/OAT/Prod?
Carlton.
January 5, 2011 at 5:52 am
Carlton Leach (1/5/2011)
Because you'll be looking to restore it if possible.
Maybe. Depends on a number of factors.
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
January 5, 2011 at 6:24 am
GilaMonster (1/5/2011)
Carlton Leach (1/5/2011)
Because you'll be looking to restore it if possible.Maybe. Depends on a number of factors.
Agreed, should have included the word 'generally' or 'probably'
January 5, 2011 at 6:41 am
its my producation server i restored my database. Now its working fine.
Thank you very much Gail and Carlton.
________________________________________
M.I.
[font="Times New Roman"]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply