Backup of SQL with application aware processing

VMware specific discussions

Backup of SQL with application aware processing

Veeam Logoby shahidpp » Sat Sep 24, 2016 11:06 am

I have an SQL instance running on Windows 2008 server.
It's heavy IO instance and using veeam backup and replication to back it up.

Is it safe to select "log truncation" in case the backup is just crash consistent?
I have selected "Try application processing, but ignore failures".

So in this scenario, is it safe to select "Process transaction logs with this job" or will it work?
If the SQL is highly transnational, what impact this can bring in during a restore?

Thanks,
Shahid
shahidpp
Novice
 
Posts: 4
Liked: never
Joined: Sat Sep 24, 2016 10:44 am
Full Name: shahid pp

Re: Backup of SQL with application aware processing

Veeam Logoby foggy » Mon Sep 26, 2016 11:31 am

Hi Shahid, logs processing is a part of application-aware image processing, so will not be performed if AAIP of the VM fails.
foggy
Veeam Software
 
Posts: 14728
Liked: 1077 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup of SQL with application aware processing

Veeam Logoby shahidpp » Mon Sep 26, 2016 11:36 am

Just a confirmation,
a file consistent backup will also ignore log truncation?
shahidpp
Novice
 
Posts: 4
Liked: never
Joined: Sat Sep 24, 2016 10:44 am
Full Name: shahid pp

Re: Backup of SQL with application aware processing

Veeam Logoby foggy » Mon Sep 26, 2016 12:17 pm

What do you mean by "file consistent"?
foggy
Veeam Software
 
Posts: 14728
Liked: 1077 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup of SQL with application aware processing

Veeam Logoby shahidpp » Mon Sep 26, 2016 2:40 pm

Hi Foggy,

I may be wrong here, there are three levels of snapshot consistency rt?
1.App
2.File
3.Crash
shahidpp
Novice
 
Posts: 4
Liked: never
Joined: Sat Sep 24, 2016 10:44 am
Full Name: shahid pp

Re: Backup of SQL with application aware processing

Veeam Logoby foggy » Mon Sep 26, 2016 2:53 pm

Please review backup consistency options available with Veeam B&R. Logs processing is performed only in case you perform application-aware processing.
foggy
Veeam Software
 
Posts: 14728
Liked: 1077 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup of SQL with application aware processing

Veeam Logoby shahidpp » Mon Sep 26, 2016 5:48 pm

Thanks for the clarification :)

Cheers,
shahidpp
Novice
 
Posts: 4
Liked: never
Joined: Sat Sep 24, 2016 10:44 am
Full Name: shahid pp


Return to VMware vSphere



Who is online

Users browsing this forum: Yahoo [Bot] and 25 guests