> -- Recover a corrupt database > > The first step is to attach the database as suspect > Create a database with an mdf of the same size as the old one > stop the server. > Copy the corrupt mdf over the newly created one. > Restart the server - the database should be suspect. > Author Nigel Rivett > http://www.nigelrivett.net/SQLAdmin/RecoverCorruptDatabase.html
Fascinating. Perhaps these other backups are not worthless just because they can't attach. I'll try one of the more recent and see if we can recover any of the recent data. We could perhaps add that to the month old data that we do have a good backup for.
You DO NOT back a SQL database up by copying the mdf file. That's the absolute best way to have a damaged and unusable 'backup'. You back a database using BACKUP DATABASE. That way you have a consistent and usable backup to restore.