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

Help, my database is corrupt. Now what? Expand / Collapse
Author
Message
Posted Saturday, February 14, 2009 4:17 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 @ 5:38 AM
Points: 42,998, Visits: 36,153
Comments posted to this topic are about the item Help, my database is corrupt. Now what?

Just an additional note, this article was tech-edited by Paul Randal.
Thanks for your time and input Paul.



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 #657263
Posted Monday, February 16, 2009 3:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:19 AM
Points: 1,116, Visits: 6,454
Great article Gail. I'll be sure to forward this on to a DBA who I know has had a few corrupt database issues.
Post #657554
Posted Monday, February 16, 2009 6:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:55 PM
Points: 11,297, Visits: 13,083
Good article Gail. Stuck it in my brief case. I just hope I never have to reference it to fix any of my DB's. :D



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #657656
Posted Monday, February 16, 2009 7:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 22, 2014 4:56 AM
Points: 1,093, Visits: 2,617
Great article Gail..... It's now permanently bookmarked :)



_______________________________________________________________________
For better assistance in answering your questions, click here
Post #657711
Posted Monday, February 16, 2009 7:44 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Good article Gail. Very descriptive. It would be in my briefcase.

SQL DBA.
Post #657720
Posted Monday, February 16, 2009 8:00 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 @ 5:38 AM
Points: 42,998, Visits: 36,153
Jack Corbett (2/16/2009)
I just hope I never have to reference it to fix any of my DB's. :D


I hope so too. This is an article that I would like no one to ever have to use. :)



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 #657745
Posted Monday, February 16, 2009 8:02 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:35 AM
Points: 3,315, Visits: 6,719
Great Article. I have added to my Breifcase. Like everyone said, I hope I never have to use it.. :D


-Roy
Post #657749
Posted Monday, February 16, 2009 8:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 7, 2014 7:51 AM
Points: 119, Visits: 541
fantastic article! easy to read, great examples, and right to the point. Now I am off to read Paul's article on what DBCC CHECKDB actually deletes when a REPAIR_ALLOW_DATALOSS is ran.

Dustin W. Jones - Database Tech.
Post #657815
Posted Monday, February 16, 2009 12:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 4:28 PM
Points: 114, Visits: 454
Nice article. I will definitely print this one out for lunchtime reading.

By the way, someone contacted me with a corrupt database a couple of years ago (they had NO backups) and I made the mistake of detaching it (yow!). This product saved my butt:

Recovery for SQL Server
http://officerecovery.com/mssql/index.htm

It can script out everything salvageable from a corrupt .mdf file and tells you what it did not get and why. When you need it, it is well worth the $499 price.

he Demo version is pretty cool in that it returns all the data with the primary keys but after the first few records puts DEMO in all the non-PK columns. With the demo you can at least see how much you are going to get back before you buy it.

Cheers.




G. Milner
Post #658004
Posted Monday, February 16, 2009 2:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:31 PM
Points: 188, Visits: 1,553
Thanks for a very informative article Gail. It has helped me understand more fully the ways to tackle corruption, the very first one being backups, log and database!

Cheers


Nicole Bowman

Nothing is forever.
Post #658091
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse