Database Data Size confusion?
I have a database on production total size is 10 GB approx, MDF = 7 GB and LDF = 3 GB, when red-gate takes backup it sends email as
10/18/2006 1:36:49 AM: Backup data size : 2.076 GB
10/18/2006 1:36:49 AM: Compressed data size: 472.404 MB
10/18/2006 1:36:49 AM: Compression rate : 77.77%
Now, I am confused since I was thinking my database is 2.076 reading these emails, but originally it is taking 10 GB on production and I was misinterpreted by the email.
What is the original size of my Database?
One event I want to mention, there was some un-used table approximately 4 GB before two weekd and I deleted them on production before that the email from red-gate was like that:
10/4/2006 1:40:50 AM: Backup data size : 6.481 GB
10/4/2006 1:40:50 AM: Compressed data size: 1.271 GB
10/4/2006 1:40:50 AM: Compression rate : 80.38%
After doing that I was happy I reduced the size of the database by 4 GB, but the original size of the database is still 10 GB.
Please, can anyone explain to me? It is very important for me?