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

errors found by DBCC CHECKDB Expand / Collapse
Author
Message
Posted Sunday, October 17, 2010 3:02 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 @ 2:22 PM
Points: 42,443, Visits: 35,497
I still need you to answer one question of mine:

GilaMonster (10/16/2010)

Do you have a clean backup of this database?


That means a backup that does not have this corruption.

p.s. Was that list that you posted from after the repairs ran or before?



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 #1005836
Posted Sunday, October 17, 2010 4:15 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 30, 2013 5:05 AM
Points: 94, Visits: 232
no I don't have a clean back up.

And that report is the last report.



Thanks and regards,
Ashkan
Post #1005846
Posted Wednesday, October 20, 2010 6:14 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 30, 2013 5:05 AM
Points: 94, Visits: 232
help please

Thanks and regards,
Ashkan
Post #1007653
Posted Wednesday, October 20, 2010 11:43 PM


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 @ 2:22 PM
Points: 42,443, Visits: 35,497
I had a chat with an expert on this. It's not good news.

If checkDB with repair allow data loss is not repairing these errors, it means that for some reason they are not repairable. Since you have no good backup, the only way that this can be fixed is if you script all the objects, export all the data that you can and recreate this as a new database.

You also might want to look into your integrity check and backup jobs as they are clearly not adequate.



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 #1008182
Posted Wednesday, October 20, 2010 11:51 PM


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 @ 2:22 PM
Points: 42,443, Visits: 35,497
I'd also suggest that you do a detailed examination of your IO subsystem, check firmware versions, check and and all logs, look for anything out of place.


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 #1008185
Posted Thursday, October 21, 2010 2:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:40 AM
Points: 7,001, Visits: 8,439
Chances are you will get errors if you just perform "select * from table".

This doesn't mean you will not be able to pull data from that table.
Try to put the primary key columns in a temp table and then write a cursor to extract as many rows as possible on a row by row basis, marking each row "trying to fetch" and "processed" in your temp table.



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

Add to briefcase ««12

Permissions Expand / Collapse