SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 corruption issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

timothyvb
Starting Member

USA
2 Posts

Posted - 10/24/2013 :  19:34:12  Show Profile  Reply with Quote
Hi all, brand new here. I've been looking into a corruption issue for a client and we are receiving the following error when running dbcc.

Msg 8928, Level 16, State 1, Line 1
Object ID 418100530, index ID 0, partition ID 27400636334080, alloc unit ID 27400636334080 (type In-row data): Page (4:5904588) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 418100530, index ID 0, partition ID 27400636334080, alloc unit ID 27400636334080 (type In-row data), page (4:5904588). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -1.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'appt_slot_templates' (object ID 418100530).
CHECKDB found 0 allocation errors and 2 consistency errors in database 'NGProd'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (NGProd).

From all the research that I've done we are looking at repairing with data loss at this point since the client doesn't have a clean back up. Any advise?

Thanks!

Tim

chadmat
The Chadinator

USA
1974 Posts

Posted - 10/25/2013 :  16:11:07  Show Profile  Visit chadmat's Homepage  Reply with Quote
That should resolve the corruption issue, but you will likely lose that page. If you have any backup that contains that page, you could try to either restore the page, or after repairing with data loss, retrieve the lost data from that backup (Even if it is old, it may be better than losing it entirely).




-Chad
Microsoft Certified Master SQL Server 2008
Go to Top of Page

prett
Posting Yak Master

USA
181 Posts

Posted - 10/29/2013 :  23:33:05  Show Profile  Visit prett's Homepage  Reply with Quote
Is there any problem with the backup?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000