We are looking at replacing traditional SQL server backups with a VSS based backup of mdf and ldf files. As a db person I'm somewhat twitchy about this, and yet I can find no evidence that this won't work?
Can anyone suggest a trial I can setup that would demonstrate where we can lose transactions with this strategy? [Yanking out the power cord during a long running transaction is fine].
The system we are looking at creates an initial snapshot of the mdf and ldf files and then copies across changes. I can't imagine a scenario where that could fail us.
Hopefully you can help me convince my boss that we need to keep traditional backups!