Comprehensive data protection for all workloads
Post Reply
sixpack
Influencer
Posts: 18
Liked: never
Joined: Jul 10, 2009 2:13 pm
Full Name: Andrew
Contact:

MS SQL Backup Consistency

Post by sixpack »

If we backup or replicate a MS SQL Server 2005 or Express server using VSS, what kind of consistency will the database be in?

Is it safe? Or is it preferable to do SQL dump/restore after a failover/restore?

Vitaliy S.
Product Manager
Posts: 24243
Liked: 1859 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: MS SQL Backup Consistency

Post by Vitaliy S. »

Hello Andrew,

If you use VSS option for your backup and replica jobs that contain VMs with MS SQL Server 2005/2008, the SQL database will be in consistent state after the backup job was performed, cause all the transactions that were in progress will be finished as well as new ones won't be started, so it will be safe to do a snapshot for this VM and this will keep your backups with highly transactional applications (such as MS SQL) in consistent state.

Thank you.

Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 34 guests