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
cja-tech-guyAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Should they be the same size or does the backup compress the file
Compress feature is only available on Enterprise Edition. Size of the file doesn't mean that all file is filled with data. Usually is empty space inside the data files. Backup size (without compression) tells you the real size of data.

You can use SSMS to see the percentage of data in each data file by choosing the Disk Usage report:
SSMS-Reports.PNG
0
 
cja-tech-guyAuthor Commented:
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
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes. 3045.38MB / 1024 = 2.97400390625 GB
0
 
cja-tech-guyAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.