SQL database file size vs. database backup file size

I'm using SQL Express 2012. The database size shows as 3958.25 MB. The size of the daily backup file for this database shows as 3045.38 MB. Should they be the same size or does the backup compress the file?

Thanks,
cja

Microsoft SQL Server

Last Comment

cja-tech-guy

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Vitor Montalvão

3/11/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

cja-tech-guy

3/11/2015

ASKER

Vitor

Attached is a screen shot of the "disk usage report". It shows the database size as 2.9 Gb which is closer to the size of the backup file. Do you think this is right? I want to make sure I can restore the entire database from the backup file if necessary.

Thanks,
cja
disk-usage-report.pdf

Vitor Montalvão

3/11/2015

Yes. 3045.38MB / 1024 = 2.97400390625 GB

cja-tech-guy

3/11/2015

ASKER

thanks

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!