I'm new to SQL server and need your advice.
I have a database that shows 188GB as the size in the database properties window.
When I take a backup of the database, that backup file is only 65GB. The database properties window still shows the database itself is 188GB.
Why is there a difference in the size of the backup compared to the actual database? I'm not using backup compression.