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?
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.