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: Monday, November 10, 2014 3:55 AM
Points: 64, Visits: 427
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 (20 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 @ 8:31 AM
Points: 40,456, Visits: 36,912
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 @ 9:21 AM
Points: 6,643, Visits: 14,230
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
Posted Thursday, July 31, 2014 3:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 1:09 AM
Points: 33, Visits: 54
You can eradicate SQL database consistency error go to replication folder of the object explorer and right click on it then select Launch Replication monitor. Then Launch Repl Monitor->My Publisher->NCFM and make a right click on it the n again select agent profile.When the Agent Profiles window is displayed, make sure the "Distribution Agents" page is selected. Then in the Agent profiles section, click and select the "Default for New" checkbox for "Continue on data consistency errors". You can click on the ellipsis button next to this profile, to view its parameters. The properties dialog box will open, and if you scroll down a bit, you will see the -SkipErrors Parameter, as highlighted below:Finally, click , and then to set the new default profile for the Distribution Agent.
Post #1598154
Posted Sunday, September 7, 2014 10:09 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 24, 2014 8:55 PM
Points: 50, Visits: 140
enriquemallon (7/31/2014)
You can eradicate SQL database consistency error go to replication folder of the object explorer and right click on it then select Launch Replication monitor. Then Launch Repl Monitor->My Publisher->NCFM and make a right click on it the n again select agent profile.When the Agent Profiles window is displayed, make sure the "Distribution Agents" page is selected. Then in the Agent profiles section, click and select the "Default for New" checkbox for "Continue on data consistency errors". You can click on the ellipsis button next to this profile, to view its parameters. The properties dialog box will open, and if you scroll down a bit, you will see the -SkipErrors Parameter, as highlighted below:Finally, click , and then to set the new default profile for the Distribution Agent.


Scary ! It doesn't even make sense.
Post #1611301
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse