Comprehensive data protection for all workloads
Post Reply
bobogs
Novice
Posts: 4
Liked: never
Joined: Mar 30, 2010 10:41 pm
Full Name: Gary
Contact:

Back up SQL Server VM w/out VSS...using Red Gate SQL Backup

Post by bobogs »

We discovered that our nightly Veeam job is doing full backups of each database on our SQL Server vm, as shown by unexpected rows where Type=D in the msdb database. This is throwing off our ability to do point-in-time recovery from our Red Gate SQL Backup SQB files created from Full, Differential and Transaction Log backups, because the Veeam Full backups interrupt the chain.

I don't see any database backup-specific settings in the Veeam job wizard...is it the VSS setting that's doing the full database backups? If I disable the VSS setting, will Veeam still be backing up the entire vm? We'd like the vm to be recoverable as a working SQL Server server (apps/binaries/DNS/etc -wise), to which we can manually restore the databases from their Red Gate SQB files as needed.

Am I on the right track with the VSS setting?

Thanks!
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Back up SQL Server VM w/out VSS...using Red Gate SQL Bac

Post by veremin »

bobogs wrote:I don't see any database backup-specific settings in the Veeam job wizard...is it the VSS setting that's doing the full database backups? If I disable the VSS setting, will Veeam still be backing up the entire vm?
If you disable Application Aware Image Processing, then, VB&R won't interfere with your primary SQL backup solution, but it will still perform VM image-level backup. Thanks.
bobogs
Novice
Posts: 4
Liked: never
Joined: Mar 30, 2010 10:41 pm
Full Name: Gary
Contact:

Re: Back up SQL Server VM w/out VSS...using Red Gate SQL Bac

Post by bobogs »

Thanks for the help. :)
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Back up SQL Server VM w/out VSS...using Red Gate SQL Bac

Post by veremin »

You're welcome. Don't hesitate to let us know, should other help be needed. Thanks.
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 234 guests