> We configure all our database server to run in full recovery mode, > then run a transaction log backup every hour and a full backup > every week. Transaction log backups overwrite after 14 days, > full backups after 4 weeks. All backups are moved to an online > backup system (which is just a NAS in a datacenter 20 miles > away).
Is the online backup system something that you're running or a service that you're utilizing? So far I've come up with two ideas. One is to increase the number of USB drives from 3 to 7 - rotate every day with one rolling out monthly and one rolling out weekly. The second is to beef up the disk space on our web server's database and create a transactional replication to that system. Any other ideas? Thanks again! Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:305538 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
