Difference b/w space available n Unused space!!!

[aruopna]

Hi All,

I could find that space available for one of the db is 484 mb. But at the same time Unused space for the same db is 12 gb.
Can somebody pls explain me the difference Difference b/w space available n Unused space in SQL 2000? If you guys didnt get me pls refer the attachment. Its a screenshot from EM.

Thanks.
AG

[rmiao]

Unused space is allocated to objects already but not been used, while available space does not allocate to any object yet. Sql counts both of them as free space.

By the way, you may see big difference between those two numbers due to out of date usage info. Can fix it by running "sp_spaceused @updateusage = 'true'" under the db.

[surya74in]

I don't think so there is difference between unused space and available space in database.if we update space usage in database both will become same. so there is no difference between in both.

[rmiao]

You can verify that in sp_spaceused, it'll tell you unused space and unallocated space.