• 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