I have same issues. RAID 5 sometimes isn't worth the money for the rebuild. I've stopped using Symantec Backup Exec because of recovery issues. We have been using MS Backup and COmodo to usb drives that we too are swapping out each night but we have to use multiple drives since we have so much data we want to keep more then 1 night on the usb drive. We are talking about putting mirroring in place to add a server that just mirrors the data on it and then do backups during the day on that mirror because sometimes the backups are not done by the next business day.
Someone I did some work for just added an NAS that their server mirrors too and then they initiate a backup of the NAS to tape. They are switching to USB because the tapes are wearing out way too fast. Just my 1 cent -----Original Message----- From: C. Hatton Humphrey [mailto:[email protected]] Sent: Monday, October 12, 2009 11:42 AM To: cf-community Subject: Database Disaster Recovery suggestions 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:305505 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
