Veeam DB and Log too big?

[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]

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]

shouldnt the logfile be much smaller? thanks.

[HannesK]

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

[info@comnovis.de]

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

[HannesK]

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

[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.