Great SQL Tool for Recovering corrupted databases - "Recovery for SQL Server"
I had someone from another unit of my company contact me yesterday. He had a database corrupted with a torn page error. (Yes, their RAID had gone on the fritz.) Many of the tables were unqueriable (is that a word?) and there were all sorts or problems and errors. I won't go into the sordid details.
Anyway, guess how recent their most recent backup was... right... NEVER! Doh!!!
So I found this tool. It will script out your entire database from a stand alone .mdb file and it will get as much of the data out for you as you are probably going to get. Check it out and save this link. It's $500 for a single user license but if you are in this situation it's well worth it. The 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.
So if your DBCC doesn't work, and your database is still corrupted, check it out: