Too Long; Didn't Read
Fast Database Recovery (FDR) is one tool that can save the day (and possibly your job) when faced with a damaged MS SQL Server. FDR's Recovery Console can be run to scan the contents of your database and present you with a list of recoverable items. FDR will not restore "live" database files - it can only apply database backups. FDR can extract single objects from a damaged MDF file without having to restore the entire database content first. FDR does NOT require the built-in check DB command to be running, unlike other 3rd party software applications that claim to repair damaged MS.