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

Recovery Model / Log SIze?

Post by felyjos »

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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Recovery Model / Log SIze?

Post by Vitaliy S. » 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
Veteran
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 »

Thanks a lot
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 180 guests