Today, I got know the size of the database. But unfortunately I could not get the correct database size on the file system until I take the back up.
Select the database, right click and click on properties.
In the above image, the size shown 460.81 MB is sum of Data and Log files. It doesn’t mean that real size of the database would be the same.
I have taken the back up of the database and on the file system the size mentioned was 262 MB.
Space Available 90.03 MB is the space that is still available to fill up. Once this space is utilized then SQL Server will allocates new Data space and Log space as per the growth rate set.
Use the following query to see the size of Log files and data files individually.
351 + 109 = 460 MB.
Hope this helps.