Space available is 0.00 MB - can not increase!!! 2

[tsave22]

Space available in the database properties is 0.00MB. Change the Space Allocated in the Data Files tab and the Transaction Log tab doesn't work. Database consistency check produce no errors What else can be done?

Thanks

 

[SQLBill]

Using Enterprise Manager, right click on the database, select Properties. Go to Data tab...what is Maximum File Size set for? Is Autogrow turned on? Check the same two things on the Transaction Log tab.

In Windows, double click on the My Computer icon. Click on the drive which has your database. How much free space is there? If there is no free space, then your hard drive is full.

-SQLBill

Posting advice: FAQ481-4875

 

[DrSql]

What type of file growth you have been set. If you set the automatic growth you dont have to make any changes, and it will grow automatically when its needed.

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[tsave22]

Unrestricted file growth, autogrow is on and 65 gb free space on hard drive. I have set to grow 10% and tried set to 10 mb - with no difference in result.

 

[DrSql]

You need to go and do an update or insert to the db to see any changes. Also try to change the growth from % to 500 MB and try to do some updates ,

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[tsave22]

Data insert and growth change to 500 mb did not change space available.

 

[SQLBill]

Run the command:

DBCC UPDATEUSAGE ('dbname')
GO

Replace dbname with your database name.

-SQLBill

Posting advice: FAQ481-4875

 

[tsave22]

Thank you so much! UPDATEUSAGE worked for my db.

 

[SQLBill]

The reason it worked is that Enterprise Manager does a poor job of keeping track of the size of things. It does not necessarily show the current values. Doing a DBCC UPDATEUSAGE resets the values in MASTER to what they really are and then Enterprise Manager can reflect reality.

-SQLBill

Posting advice: FAQ481-4875