Backing up SQL Server DB's

VMware specific discussions

Backing up SQL Server DB's

Veeam Logoby thomasellaby » Mon Jun 19, 2017 11:23 pm

Hi All,

Whats the general consensus on backing up SQL Servers? We are currently doing VM level backups of the SQL Server through Veeam as well as through the SQL Server Management Studio as a backup job. This seems redundant to me as we have alot more functionality doing it through Veeam and by doing the local SQL backups we are just chewing up space for no reason...

Thoughts?


Thomas
thomasellaby
Novice
 
Posts: 3
Liked: never
Joined: Thu Aug 18, 2016 10:59 pm
Location: Brisbane, QLD, Australia
Full Name: Thomas Ellaby

Re: Backing up SQL Server DB's

Veeam Logoby mcrape » Tue Jun 20, 2017 12:27 am

I tend to clump my SQL Servers together into their own job and make sure I have SQL application aware processing turned on. This allows me to have many point in time backups (down to the transaction). I've actually used these point-in-time backups to see when specific queries have run, trying to troubleshoot other issues.

I also tend to use an in-guest backup program to backup my SQL DBs to S3 or Google Cloud. This is for longer-term retention (e.g. years) and runs twice a day.

Rarely do I need to go for the long-term backups, so Veeam with the application-aware enabled tends to do a great job.
mcrape
Veeam Vanguard
 
Posts: 48
Liked: 20 times
Joined: Mon Jun 27, 2011 7:39 pm
Full Name: Matt Crape

Re: Backing up SQL Server DB's

Veeam Logoby skrause » Tue Jun 20, 2017 4:16 pm

Whatever method you decide to use for the database level backups (be that through SQL's native tools, or through Veeam's tools) you will want to make sure you do both a server level backup as well as doing some form of SQL backup that processes logs so you can do point-in-time restores of the databases themselves.
Steve Krause
Veeam Certified Architect
skrause
Expert
 
Posts: 296
Liked: 45 times
Joined: Mon Dec 08, 2014 2:58 pm
Full Name: Steve Krause


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 28 guests