Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
info@comnovis.de
Novice
Posts: 6
Liked: never
Joined: Feb 12, 2019 3:15 pm
Full Name: Comnovis
Contact:

Veeam DB and Log too big?

Post by info@comnovis.de »

the files C:\Program Files\Microsoft SQL Server\MSSQL10_50.VEEAMSQL2008R2\MSSQL\DATA\VeeamBackup.mdf
and C:\Program Files\Microsoft SQL Server\MSSQL10_50.VEEAMSQL2008R2\MSSQL\DATA\VeeamBackup_log.LDF
each are almost 2gb size. should this be less? if so, how to achieve that?
host is hyper-v 2012 which is not backed up itself (no need)

HannesK
Veeam Software
Posts: 5657
Liked: 769 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

Re: Veeam DB and Log too big?

Post by HannesK »

Hello,
that size sounds good for me. I have almost 1GB in my home lab with only a couple of VMs, so 2GB sound reasonable to me.

Best regards,
Hannes

info@comnovis.de
Novice
Posts: 6
Liked: never
Joined: Feb 12, 2019 3:15 pm
Full Name: Comnovis
Contact:

Re: Veeam DB and Log too big?

Post by info@comnovis.de »

shouldnt the logfile be much smaller? thanks.

HannesK
Veeam Software
Posts: 5657
Liked: 769 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

Re: Veeam DB and Log too big?

Post by HannesK »

as long as the recovery model is set to simple, I see no issue.

Image

info@comnovis.de
Novice
Posts: 6
Liked: never
Joined: Feb 12, 2019 3:15 pm
Full Name: Comnovis
Contact:

Re: Veeam DB and Log too big?

Post by info@comnovis.de »

this can be changed in SQL Server Management Studio i guess?

HannesK
Veeam Software
Posts: 5657
Liked: 769 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

Re: Veeam DB and Log too big?

Post by HannesK »

yes, that's shown in my screenshot. But TSQL also works "ALTER DATABASE Your-database-name SET RECOVERY ..."

info@comnovis.de
Novice
Posts: 6
Liked: never
Joined: Feb 12, 2019 3:15 pm
Full Name: Comnovis
Contact:

Re: Veeam DB and Log too big?

Post by info@comnovis.de »

for others with the same Question:
the following cmd command generates a txt file in c:\temp showing your databases, including recovery model (simple in my case):
sqlcmd -S .\VEEAMSQL2008R2 -Q "select * from sys.databases" >c:\temp\sql.txt

the SQL instance Name "VEEAMSQL2008R2" can be different, depending on what you have installed.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 5 guests