Sql 2000 Server Space Usage

[eggy168]

I have a database that the Data has the size 7980.37 MB, according to the Space Available, it has 16.93 MB. The Transaction Log space 19.99MB, Free space 19.3 MB.

However, when I use the sp_Spaceused, the Unallocated Space is -1.94 MB.

I am wondering is it something wrong of the spaced allocated that I need to alter something? I tried to Shrink Database, but there is no maximum free space in files I can shrink by percentage.

I am now having this database restricted to any user except myself. I am afraid the database will expose at some point. Is there anyway I can fix the Space Allocated?

Thank You

 

[ptheriault]

First run

DBCC UPDATEUSAGE(<db_name>)

This will update your usage stats so you are looking at the most recent data.

What is your available disk space?
Right click on your database in Enterprise Manager and select properties. On the files tab is your database set to auto grow. IF not you should either change it to auto grow or change your initial size to increase the size of your data file. The log file should always be set to auto grow without a defined limit.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[eggy168]

The disk space is 45 GB on the server which is 1/2 of 79GB has been used. I think it is fine, right?
I set the Autogrow on the data file and transaction log already.
The only thing bothers me is I view the database by the TaskPad, the Space Allocated is 0MB in the Data. I am wondering what else I can do?
Thank You.

 

[ptheriault]

Nothing. It should hit an autogrow soon. Did you run updateusage?
Here are my thought on auto grow.
When your database hits an autogrow it will impact performance of the database. It is best to manually mangage the growth events of your database off hours. you can write TSQL db alter scripts to do that and schedule them with SQL Server agent.

- Paul

- If at first you don't succeed, find out if the loser gets anything.