I would have a job that runs every 15 minutes and rotates the files every hour. So, I would never have more than 4 snapshots no older than an hour....

good point. was not thinking that far out.

Brandie Tarvin (3/18/2010)

Any chance I can change your mind on this? Relying on db snapshots as a permanent part of your backup plan is not necessarily a good idea.

Snapshots...

I think the best solution for us will be database snapshots every 15 minutes. This comes with a price. Losing transactions between snapshots. But, restore time is just a few...

Wasn't an app. It was a developer dba running a script that dropped the tables. Thought I could go back in time to a point without having tio restore full...