I am not a DBA but a developer so please bear with me.
The size of my db is 10929.50 MB (10GB), but when I took the backup and compressed it, the size of file was reduced to about 3.5GB.
I detached the db and zipped (.mdf + .ldf) using 7zip and the size of zip file was also around 3.5 GB.
I am wondering why is that and why my db size is showing 10GB. Is my db inflated?
By the way Recovery model is set to Simple.
I would really appreciate if someone can shed some light on this.