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

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.
VP, Product Management
Posts: 26784
Liked: 2655 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

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: Ahrefs [Bot], oleg.feoktistov, Semrush [Bot], tstout and 167 guests