-
- Novice
- Posts: 6
- Liked: never
- Joined: Oct 30, 2009 1:56 pm
- Full Name: Jake
- Contact:
Veeam B&R Database Size
I recently upgraded our Veeam installation from v5 to v6. Veeam runs on a single physical server and currently uses network based backups to connect to our three vSphere 4.0 hosts and backup our ~30 VMs. The Veeam server has MS SQL 2005 installed (not express) locally. Since the upgrade, I've noticed that the Veeam database log file grows very large at times. It came to my attention when I ran out of space on the disk and realized the LDF file was more than 70GB in size. I noticed that the full Veeam database backup file is only around 50MB, so I don't really think there are any uncommitted transactions in the log file. I was able to shrink the log file and also reset the initial size setting via a script I found on MSDN, but I've noticed that over the course of two nights, the log file has grown again from 200MB to more than 1GB. My question is what types of transactional data is stored within the log file and does anyone have any idea why I may be seeing this issue now? Thanks!
-
- VP, Product Management
- Posts: 27302
- Liked: 2775 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Veeam B&R Database Size
Hi Jake, what is the recovery model used for Veeam B&R database?
-
- Novice
- Posts: 6
- Liked: never
- Joined: Oct 30, 2009 1:56 pm
- Full Name: Jake
- Contact:
Re: Veeam B&R Database Size
Hi Vitaliy, the database is set to Full. I don't think I've ever changed it, so that must have been what it was after being installed by Veeam v4 a couple of years ago unless a subsequent Veeam upgrade changed it.
-
- Chief Product Officer
- Posts: 31631
- Liked: 7128 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: Veeam B&R Database Size
Jake, please just change the recovery mode of Veeam database to simple. Thanks!
Who is online
Users browsing this forum: Baidu [Spider], Bing [Bot] and 34 guests