On Monday, April 22, 2013, Moshe Jacobson wrote:
We have a report in our system that is pulled many times each week, but needs to be based off data from Sunday at noon. So every Sunday at noon, we back up our main database and restore it into a new reporting snapshot database.
The problem is that backing up and restoring the database every week is a very costly operation that can take many hours. It brings the system to its knees.
How do you do normal backups, for disaster recovery purposes? Could you merge that with your snapshotting needs to reduce the workload on your main server from two to one?
Cheers,
Jeff