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

Veeam DB and Log too big?

Post by info@comnovis.de » Feb 13, 2019 10:58 am

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: 4015
Liked: 493 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

Re: Veeam DB and Log too big?

Post by HannesK » Feb 13, 2019 11:36 am

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: 5
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 » Feb 13, 2019 11:55 am

shouldnt the logfile be much smaller? thanks.

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

Re: Veeam DB and Log too big?

Post by HannesK » Feb 13, 2019 12:17 pm

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

Image

info@comnovis.de
Novice
Posts: 5
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 » Feb 13, 2019 1:47 pm

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

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

Re: Veeam DB and Log too big?

Post by HannesK » Feb 13, 2019 1:50 pm

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

info@comnovis.de
Novice
Posts: 5
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 » Feb 13, 2019 2:12 pm

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: No registered users and 15 guests