Help, my database is corrupt. Now what?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gail Shaw » Help, my database is corrupt. Now what?

Add to briefcase

84 posts, Page 1 of 9

1 2 3 4 5 »»»

Help, my database is corrupt. Now what?

Expand / Collapse

Author

Message

Posted Saturday, February 14, 2009 4:17 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 37,669, Visits: 29,923

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

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:12 AM
Points: 959, Visits: 6,341

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

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:02 PM
Points: 1,058, Visits: 2,574

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

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

Good article Gail. Very descriptive. It would be in my briefcase.

SQL DBA.

Post #657720

Posted Monday, February 16, 2009 8:00 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:01 PM
Points: 37,669, Visits: 29,923

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

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 3,280, Visits: 6,620

Great Article. I have added to my Breifcase. Like everyone said, I hope I never have to use it.. :D

-Roy

Post #657749

Dustin W. Jones

Posted Monday, February 16, 2009 8:47 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:48 PM
Points: 106, Visits: 459

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

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:36 PM
Points: 111, Visits: 410

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

Group: General Forum Members
Last Login: Today @ 3:53 PM
Points: 171, Visits: 1,398

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

84 posts, Page 1 of 9

1 2 3 4 5 »»»

Permissions

Expand / Collapse