Prev: Replication Issue
Next: .net runtime optimization service event viewer Error
From: hayko98 on 22 Feb 2010 13:37
Hi All

I have SQl Server 2000.Log file was out of space(error 9002).I checked
settings for log file and it was Autogrowth/10%/unristicted.Drive has
20GB free space.I added space for log file and data.

Now , when i am checking Db properties it still shows :Space
available: 0.00MB

Any ideas Why?

Thank You
From: SQLSQUIRREL on 22 Feb 2010 22:57
Hi Hayk,

When you "added" disk space did you grow the drives that the data and log
files were on?... Or did you and additional log and data files?... For the
log files make sure you have transaction log backups if the databse recovery
model is full or make sure your SQL Server is successfully executing
CHECKPOINTS on the database(s) if the recovery model is simple.

Please provide more information.

Squirrel
http://www.lockergnome.com/sqlsquirrel/


"hayko98" wrote:

> Hi All
>
> I have SQl Server 2000.Log file was out of space(error 9002).I checked
> settings for log file and it was Autogrowth/10%/unristicted.Drive has
> 20GB free space.I added space for log file and data.
>
> Now , when i am checking Db properties it still shows :Space
> available: 0.00MB
>
> Any ideas Why?
>
> Thank You
> .
>
From: Paul Rairdon on 23 Feb 2010 10:52
On Feb 22, 10:37 am, hayko98 <vardan.hakop...(a)gmail.com> wrote:
> Hi All
>
> I have SQl Server 2000.Log file was out of space(error 9002).I checked
> settings for log file and it was Autogrowth/10%/unristicted.Drive has
> 20GB free space.I added space for log file and data.
>
> Now , when i am checking Db properties it still shows :Space
> available: 0.00MB
>
> Any ideas Why?
>
> Thank You

Try running DBCC updateusage (@DBname) and refresh your view and see
if that changes anything.

Paul
 | 
Pages: 1
Prev: Replication Issue
Next: .net runtime optimization service event viewer Error