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 12»»

DBCC checkdb lifecycle Expand / Collapse
Author
Message
Posted Monday, August 26, 2013 2:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, November 2, 2014 11:16 AM
Points: 202, Visits: 360
I first ran DBCC CHECKDB on an instance. It threw away around 2000 consistency errors.
I ran repair_rebuild and it didn't fix any errors.
Then I ran dbcc with REPAIR_ALLOW_DATA_LOSS and it fixed around 1900 consistency errors.

I switched DB into multi user mode again and am running checkdb again.

is there a way I can fix the remaining 100 odd errors?
Post #1488317
Posted Monday, August 26, 2013 3:12 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 @ 7:43 AM
Points: 40,438, Visits: 36,894
Firstly why did you repair rather than restoring a clean backup? Repair is typically the last resort, not the first solution.

Do you know how much data was lost?
Do you know what data was lost?
Do you know what effect that lost data will have on your business?

Please run the following and post the full and complete, unedited output.
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS




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 #1488331
Posted Monday, September 9, 2013 2:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, November 2, 2014 11:16 AM
Points: 202, Visits: 360
GilaMonster (8/26/2013)
Firstly why did you repair rather than restoring a clean backup? Repair is typically the last resort, not the first solution.

Do you know how much data was lost?
Do you know what data was lost?
Do you know what effect that lost data will have on your business?

Please run the following and post the full and complete, unedited output.
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS


Hi,

Will be backup be clean without inconsistencies?
Post #1492687
Posted Monday, September 9, 2013 3:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:21 AM
Points: 6,743, Visits: 8,517
it depends if the backup has been taken before the corruption occured.

One way of testing this is using Allens automation script : Test Your SQL Server Backups with PowerShell


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1492699
Posted Monday, September 9, 2013 3:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:21 AM
Points: 6,743, Visits: 8,517
If corruption re-occurs, it is time to check your disks, .. double check if your case can be found in the BUGs of Service packs or Cumulative updates you didn't install at this instance and/or contact PSS.

Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1492710
Posted Monday, September 9, 2013 4:25 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 @ 7:43 AM
Points: 40,438, Visits: 36,894
Benki Chendu (9/9/2013)
GilaMonster (8/26/2013)
Firstly why did you repair rather than restoring a clean backup? Repair is typically the last resort, not the first solution.

Do you know how much data was lost?
Do you know what data was lost?
Do you know what effect that lost data will have on your business?

Please run the following and post the full and complete, unedited output.
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS


Hi,

Will be backup be clean without inconsistencies?


Well, I specified 'clean backup', so one without corruption in it.



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 #1492724
Posted Monday, September 9, 2013 8:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, November 2, 2014 11:16 AM
Points: 202, Visits: 360
I also see stack dumps getting generated.
Am planning to engage MS to decipher the stack dump.
Makes sense?
Post #1492809
Posted Monday, September 9, 2013 11:16 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 @ 7:43 AM
Points: 40,438, Visits: 36,894
If you want to pay them, sure.


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 #1492877
Posted Monday, September 9, 2013 11:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, November 2, 2014 11:16 AM
Points: 202, Visits: 360
Not really.
I was almost clueless
Can you please help me if you can
Post #1492878
Posted Monday, September 9, 2013 11:41 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 @ 7:43 AM
Points: 40,438, Visits: 36,894
GilaMonster (8/26/2013)
Please run the following and post the full and complete, unedited output.
DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS




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 #1492885
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse