SQL 2000 database out of space!

The drive is almost full. Shrinking does not help. The transaction log backup fails because there is not enough space. I changed the recovery model to 'Simple' and now I have plenty of space. The log is cleared. I know this is just a work around, but this database is not mission critical so I am good!

I need a 'top' for windows.

I will use tasklist and sort by ram usage:

tasklist | sort /+60 (XP)

tasklist | sort /+65 (2003/2008)

Then I will sort by CPU Time:

tasklist /v | sort /+77 (All)

chrome.exe 5708 Console 0 48,612 K

chrome.exe 31432 Console 0 78,444 K

iexplore.exe 11168 Console 0 103,052 K

Image Name PID Session Name Session# Mem Usage

========================= ====== ================ ========

C:\>