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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER
It is Full recovery model.
but I guess full backup is about backing up the data in .mdf file, right?