question

OCMC avatar image
OCMC asked

Database size

Our SQL 2005 database is supposed to be 300mb. we were being told the database is full I queried: use "MY_DB" exec sp_spaceused and got: database_name = MY_DB database_size = 12.00mb unallocated space = 1.72mb Two quick questions. 1. Why would anyone tell us we're full? 2. Why doesn't unallocated space equal 288mb? Thanks
sql-server-2005database-size
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
Try rerunning the command like this: EXEC sp_spaceused @updateusage = N'TRUE'; Be sure you're in the right database too.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OCMC avatar image OCMC commented ·
thanks so much for getting back to me so fast. I tried this and got Command executed. Is there a way a see the results? Thanks so much.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
You should see an updated set of data showing the space used and the space allocated for the database in question.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.