Discussions specific to the VMware vSphere hypervisor
Post Reply
shahidpp
Novice
Posts: 4
Liked: never
Joined: Sep 24, 2016 10:44 am
Full Name: shahid pp
Contact:

Backup of SQL with application aware processing

Post by shahidpp » 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

foggy
Veeam Software
Posts: 18295
Liked: 1569 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of SQL with application aware processing

Post by foggy » 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.

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

Re: Backup of SQL with application aware processing

Post by shahidpp » Sep 26, 2016 11:36 am

Just a confirmation,
a file consistent backup will also ignore log truncation?

foggy
Veeam Software
Posts: 18295
Liked: 1569 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of SQL with application aware processing

Post by foggy » Sep 26, 2016 12:17 pm

What do you mean by "file consistent"?

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

Re: Backup of SQL with application aware processing

Post by shahidpp » 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

foggy
Veeam Software
Posts: 18295
Liked: 1569 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of SQL with application aware processing

Post by foggy » 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.

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

Re: Backup of SQL with application aware processing

Post by shahidpp » Sep 26, 2016 5:48 pm

Thanks for the clarification :)

Cheers,

Post Reply

Who is online

Users browsing this forum: No registered users and 12 guests