Comprehensive data protection for all workloads
Post Reply
felyjos
Expert
Posts: 285
Liked: 3 times
Joined: Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN
Contact:

Recovery Model / Log SIze?

Post by felyjos » May 09, 2012 12:34 am

Hello,

What is the best practice to prevent the VeeamBackup Log file to be HUGE .... 50 Gb for a DB of 120 MB!!!! ?
Is the Rcovery Model Full mandatory? Why?

For now I could change the recovery model to SIMPLE, shrink the log and then back to FULL but is it worthy?

Thanks,
DOm

Vitaliy S.
Product Manager
Posts: 22445
Liked: 1443 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Recovery Model / Log SIze?

Post by Vitaliy S. » May 09, 2012 9:32 am 1 person likes this post

Hi Dom,

Full Recovery mode is not mandatory, moreover when you choose to setup local SQL Express database (default setup option), Veeam B&R will set up its configuration database with Simple recovery mode configured. With simple recovery mode, you do not have to worry about the transaction log management.

Thanks!

felyjos
Expert
Posts: 285
Liked: 3 times
Joined: Jun 08, 2011 5:46 pm
Full Name: Dominique DUCHEMIN
Contact:

Re: Recovery Model / Log SIze?

Post by felyjos » May 09, 2012 1:15 pm

Thanks a lot

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], Majestic-12 [Bot] and 20 guests