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?
-
sixpack
- Influencer
- Posts: 18
- Liked: never
- Joined: Jul 10, 2009 2:13 pm
- Full Name: Andrew
- Contact:
-
Vitaliy S.
- VP, Product Management
- Posts: 27120
- Liked: 2720 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: MS SQL Backup Consistency
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.
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.
Who is online
Users browsing this forum: david.domask, esa.riikonen, Markush-VE and 183 guests