I ended up fixing my database issue by copying the data from one database to another... so that's fixed but now I'm being asked how we can prevent this from happening in the future.
What happened: one of the members of a RAID 5 array died. The rebuild worked fine but when it was done we had lost one little-used database (restored from an old backup) and had the structure of 5 tables in another get corrupted (two of them happened to be Sysindexes and sysobjects). The owners are asking me to theorize as to why this happened and what can be done to prevent it from impacting us as badly as it did this time. I'm at a loss as to what to suggest - I know enough about server hardware and backup solutions to use what we have and be dangerous beyond that. Does anyone have any suggestions for what to include? I know that the hardware needs to be replaced; the server is 5 years old! I'm wondering if there is a service not unlike Carbonite that can provide historical backup services for upwards of a week or two of either the BAK or MDF files. For our backups right now we have Symantec Backup Exec System Recovery that takes an image of each drive on week-nights, then a different process that copies the backup files to a removable USB hard drive. These drives then get swapped out on a daily basis. The reason we got in to the "pickle" that we did was because by the time we discovered the failures we had already cycled through 3 days which meant any good backup was overwritten. Yeah, it sucks having to go through this but it's definitely been a learning experience! Until Later! C. Hatton Humphrey http://www.eastcoastconservative.com 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:305502 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
