Post reply

SQL server 2000 occupied all harddisk space

  • October 26, 2007 at 10:23 am

    #70376

    Hi,

    I am new to this, I am running a SQL 2000 on a virtual PC for testing and trying out simple SQLs. No critical DBs are running except, the only other application here is MOM2005 installed along on the same virtual PC as I am trying it out as well. However, just recently I the harddisk space on this virtual PC reaches full, as in 100%.

    Short of deleting the virtual PC and start from scratch again, anything I can do to release harddisk space as I notice there are some log files quite huge?

    For reference, I can clear out some a few hundred mb temporary for working space, but need to move these few hundred mb back afterwards.

    Thanks in advance.

    Simone

  • October 26, 2007 at 10:32 am

    #745821

    You might try changing the recovery model property on the database to "simple".. it's probably setup as "full".. and then do a shrink file and choose your log file, or just shrink the db.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply