Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBCC Checkdb consistency Error on Production Database Expand / Collapse
Author
Message
Posted Tuesday, January 14, 2014 12:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 1:14 AM
Points: 60, Visits: 401
Hi All,

My production server details are :

Microsoft SQL Server 2005 - 9.00.5000.00 (X64)
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 5.2 (Build 3790: Service Pack 2)

I have had a consistency error on one of my databases last week in a non clustered index on a table and I had dropped and recreated the non-clustered index to get rid of it.

Following the incident, I came across another cnsitency check error on the same table and I have attached a complete dump of the error.

Is repair_allow_data_loss the only option here? Do I have to take a downtime for this activity since this is a critical production database?

Thanks in advance..



  Post Attachments 
SQLDump0018.txt (15 views, 20.10 KB)
Post #1530557
Posted Tuesday, January 14, 2014 5:22 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 AM
Points: 42,445, Visits: 35,501
Please run the following and post the full and complete, unedited output

DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Do you have a clean backup and an unbroken log chain from that clean backup?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1530626
Posted Tuesday, January 14, 2014 2:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:09 AM
Points: 6,170, Visits: 13,311
Doesnt look good for that table, as Gail said do you have a clean backup and unbroken log chain. If not, why not

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1530870
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse