Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
VincentWRX
Novice
Posts: 7
Liked: never
Joined: Jun 07, 2023 6:08 am
Full Name: Vincent
Contact:

Big backup size mdf files?

Post by VincentWRX »

We got multiple backups running on different servers to a cloud storage.
Because they got databases on them it seems the backup every day is between 5-15GB.
This looks mainly because they got mdf files/databases on their server. I've already set guest processing on and used a username to truncate logs.

Is there any way to lower down the backup of those database files?

Too bad it's not possible to be sure it's the mdf files as you can't see what is in a daily backup.
Mildur
Product Manager
Posts: 10316
Liked: 2754 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Big backup size mdf files?

Post by Mildur »

Hello Vincent

A higher change rate with database files is expected.
Which backup mode (Volume or File level?) and which Agent version are you using for the backup?

Best,
Fabian
Product Management Analyst @ Veeam Software
VincentWRX
Novice
Posts: 7
Liked: never
Joined: Jun 07, 2023 6:08 am
Full Name: Vincent
Contact:

Re: Big backup size mdf files?

Post by VincentWRX »

Also got errors like this in the backup.
[24.05.2023 03:56:58] Info <1f3c> Database 988: skipped transaction log truncation.

#MOD: Please do not post Log files, it's against our forum policy.
VincentWRX
Novice
Posts: 7
Liked: never
Joined: Jun 07, 2023 6:08 am
Full Name: Vincent
Contact:

Re: Big backup size mdf files?

Post by VincentWRX »

We use different methods.
Volume backup and Entire computer backup
And using the newest agent 6.0.2.1090
Mildur
Product Manager
Posts: 10316
Liked: 2754 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Big backup size mdf files?

Post by Mildur »

Thanks for the information.
I checked my lab and 5-15GB is not big on windows server where applications are running.

For the information about the skipped transaction log truncation, please make sure that permissions are set correctly for the MSSQL server. Maybe you have only databases in the simple recovery model, which doesn't require log truncating.
If correct permissions are set and your database is using Full recovery model, please check with our customer support why the log truncation is skipped.

Best,
Fabian
Product Management Analyst @ Veeam Software
VincentWRX
Novice
Posts: 7
Liked: never
Joined: Jun 07, 2023 6:08 am
Full Name: Vincent
Contact:

Re: Big backup size mdf files?

Post by VincentWRX »

Oke thanks for the information. We moved to Veeam from Iaso and found out that veeam backups are way bigger per month as the iaso ones.
Post Reply

Who is online

Users browsing this forum: No registered users and 20 guests