Host-based backup of VMware vSphere VMs.
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 »

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: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of SQL with application aware processing

Post by foggy »

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 »

Just a confirmation,
a file consistent backup will also ignore log truncation?
foggy
Veeam Software
Posts: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of SQL with application aware processing

Post by foggy »

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 »

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: 21138
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Backup of SQL with application aware processing

Post by foggy »

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 »

Thanks for the clarification :)

Cheers,
Post Reply

Who is online

Users browsing this forum: Bing [Bot], Semrush [Bot] and 61 guests