Link to home
Start Free TrialLog in
Avatar of msdba
msdba

asked on

Full Backup size bigger than .mdf file

Hi All, I have a database with .mdf file size under 2 GB and .ldf is right now 37GB for some reason.

When I took a full backup on the database, I surprised to see  the backup file to be 39GB when the .mdf file is only 2gb.

I though full backup will create a checkpoint and will flush out all the commited transactions in the .ldf to .mdf so that all the commited trasaction on teh .mdf file will be backed up and backup file size will reflect the size of .mdf file size.


but it proves wrong as the backup i had is the sum of .mdf and .ldf.

is that true, will the full backup size be the sum of size of bth .mdf and .ldf?
and why do backup include the un commited transactions in the .ldf files?

ASKER CERTIFIED SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of msdba
msdba

ASKER

Thanks for the comment.
It is Full recovery model.


but I guess full backup is about backing up the data in .mdf file, right?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of msdba

ASKER

thanks