** Private ** wrote: > 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.
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). With such a model the only thing you need to watch out for is whether your restore time (full backup + roll-forward of up to 177 hourly backups) is within the SLA parameters. But on average the size of an hourly transaction log backup is less then 1% of a full backup, so the total storage requirements are a lot lower then when we did daily full backups. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:305524 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
