How can I backup the mdf and ldf files with vss?

Question

How can I backup the mdf and ldf files with vss?

rewerma opened this issue 5 years ago · 3 comments

Hi,
When I create the snapshot by AlphaVSS, it seems not using SqlServer writer to freeze IO.
The mdf and ldf files timestamp is the old. It is not flush.

May I do something to freeze IO and flush data when create the snapshot ?

Answer 1 · 2019-11-12T16:05:19.000Z

I don't have personal experience working with SQL Server backups using VSS unfortunately. Hoping someone else can be of assistance.

Answer 2 · 2019-12-20T16:37:55.000Z

@rewerma ⚠️ You don't want to, especially on a production system. ⚠️ Look up Brent Ozar's blog for the details. https://www.brentozar.com/archive/2018/01/perils-vss-snaps/

Answer 3 · 2020-03-19T17:04:17.000Z

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.