Host-based backup of VMware vSphere VMs.
Post Reply
stewsie
Expert
Posts: 247
Liked: 20 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Backup SQL using Veeam or SQL tools

Post by stewsie »

Hi

How are people generally backing up SQL? Using Veeam with application aware processing or using the native SQL backup facility?

During a recent best practice webinar I asked the question and was told that there was no real benefit in using Veeam over SQL tools. I can see that using Veeam adds more complexity and potential for failure should any of the accounts being used have a problem.

Thanks
ejenner
Veteran
Posts: 636
Liked: 100 times
Joined: Mar 23, 2018 4:43 pm
Full Name: EJ
Location: London
Contact:

Re: Backup SQL using Veeam or SQL tools

Post by ejenner »

Our DBA mainly does the SQL backups, so I have set Veeam to do occasional SQL backups without truncating logs just as a backup to the backup.

What sort of account problem were you thinking of?

I'm not aware of how much the built-in SQL tools have advanced since I last used them... maybe they've come on a long way, maybe they're only as good as they used to be? But I think the advantage you're going to get from a Veeam backup over a 'tools' backup is granular restoration, roll-back to earlier point in time capability and of course once the backup is in Veeam you can benefit from the maintenance of the backup files and the ability to copy off to another location ect...i.e. better safety of your backed up data.
stewsie
Expert
Posts: 247
Liked: 20 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Backup SQL using Veeam or SQL tools

Post by stewsie »

I was just thinking that managing the accounts that have local access to the server and database could cause problems.

I already take a backup of the database VMs using Veeam just not using the AAIP so in the event of a restore the DBA just restore the database once the VM is online again. A two step process but without any possible complications
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup SQL using Veeam or SQL tools

Post by foggy »

Hi Paul, it's completely up to you what SQL Server backup approach to select, just note that Veeam B&R automates SQL point-in-time restore allowing you to select even a specific transaction to restore the database up to and also allows the restore of a particular database schema objects and tables data.
stewsie
Expert
Posts: 247
Liked: 20 times
Joined: May 22, 2015 7:16 am
Full Name: Paul
Contact:

Re: Backup SQL using Veeam or SQL tools

Post by stewsie »

Thanks all for the input
Post Reply

Who is online

Users browsing this forum: Google [Bot], StrongOBackup and 93 guests