Database space available error

i am getting incorrect value while trying to retrieve space available ina database using sql dmo..

i am using sql server express 2005

Hard to help you without knowing the code you are using. Please post it here in order to help you. What are you getting back, what are you expecting ? Why are you expecting this value and not the actual presented by DMO ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

databaseobject->get_spaceavailable(&space);

when i check this value with original value .ie. value known by opening database management is diferent

database properties show incorrect information

The backup file size for database xyz shows the size of 200,000kb.

However when I click on the property from enterprise manager, it shows 3000MB. What is the reason that the backup file shows a much smaller size than the size that showed from EM db property?

Thanks for your input!

Database files have a "reserved" space which wil give you the availbility, as in your case to put data up to 3000MB to it, before it will grow (if set up). The backup file on the other side will only backup the data not the reserved space which might be not occupied. You will need to have a look in a procedure like sp_Spaceused or the proper view in Enterprise Manager to get the occupied values.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de