Comprehensive data protection for all workloads
Post Reply
jw_ic
Enthusiast
Posts: 34
Liked: never
Joined: Oct 25, 2017 1:26 pm
Full Name: James Wuerflein
Contact:

application aware backups for Linux and SQL Servers

Post by jw_ic »

Looking to see if there is a way to do application aware backups for Linux VMs that have MS SQL Server with Veeam?

With linux not really having VSS / VSS writers to make sure in flight transactions are written to disk, wondering if this can be done? Obviously, backups to the local disk and then backing that up with Veeam, but other than doing that?
Egor Yakovlev
Veeam Software
Posts: 2536
Liked: 680 times
Joined: Jun 14, 2013 9:30 am
Full Name: Egor Yakovlev
Location: Prague, Czech Republic
Contact:

Re: application aware backups for Linux and SQL Servers

Post by Egor Yakovlev »

Hi James.
I am not sure if MS SQL on Linux supports dbcc freeze_IO\thaw_IO(worth a check!), so best approach would be SQL-native local backup(via scheduled task or sqlcmd script) and VM level backup with Veeam. Entire process can be automated using build in feature in Veeam to run pre-job script(create local backup file on a server) and post-job script(delete local backup file to save space).
That way you will have both of two worlds - an image based backup of entire SQL VM with 100% consistent MS SQL DB backup on it's disk.
/Cheers!
thomas.biesmans
Enthusiast
Posts: 36
Liked: 13 times
Joined: Mar 22, 2013 10:35 am
Contact:

Re: application aware backups for Linux and SQL Servers

Post by thomas.biesmans »

+1 ;) Are there are any current plans to support SQL on Linux through application aware processing with Veeam? Current workaround notwithstanding, automatic integrations are just so much better.
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: application aware backups for Linux and SQL Servers

Post by Vitaliy S. » 1 person likes this post

Hey Thomas, there are no short-term plans for this feature, so scripting should be a way to go. Thanks!
thomas.biesmans
Enthusiast
Posts: 36
Liked: 13 times
Joined: Mar 22, 2013 10:35 am
Contact:

Re: application aware backups for Linux and SQL Servers

Post by thomas.biesmans »

Thank you very much for the speedy response Vitaliy!
Post Reply

Who is online

Users browsing this forum: Baidu [Spider], NightBird and 177 guests