We had a drive in the RAID 5 array that stores our MSSQL database files (the .MDF's) that we repaired successfully... or so we thought. Now we've encountered two problems (so far) with the SQL databases.
The first was a torn page that we corrected by restoring from a backup. The second appears to be an indexing error. We ran a DBCC CHECKDB and found errors in SysIndexes (a system table - this is SQL 2000, not 2005) and three user tables. Currently we have no tools on-hand to deal with an issue like this. Restoring *this* database is not an option because of the sheer amount of manhours needed to recreate all of the data. I've found a couple of "repair and recovery" tools that look promising but I wanted to poll the group to see if any of you had suggestions and experience with anything. What I'd love to have is something that will handle things like a Transaction Log restore as well as other database repair operations. Also, are these tools just running SQL tasks behind the scenes or are they performing actions that are not available normally? Thanks! Until Later! C. Hatton Humphrey No trees were killed in the sending of this message, but a large number of electrons were terribly inconvenienced. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:305230 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
