Yesterday I was desperate trying to get a sql server to run apparently some user uploaded a huge amount of data to the
small development server ( the application of course is not finished)
and it killed all other processes running on the server .
before going into production the apps go into a small SQL2000 server running on windows 2003
and somebody ate all the hard drive space (40 GB) with a single database (they tried to pull all the information
from the mainframe) and I had a 6 GB database with a 22 GB database log
the database file is called compilator_data.mdf and the log file WAS called compilator_data.ldf
in the same server we have another 5 databases that we're working on
and nobody could work
it was 2 AM in the morning and having only 384 KB of free space regrettably i did the following.
a) Tried to Shrink the database the shrink was successful but the database and log file size remained the same
b) erased all the backups from the server and tried to do a backup of the database and it did not complete due to lack of HD space
c) Unmounted (took offline) the database and erased the log and then tried to restart the database and nothing
What can I Do?
Should I clear my desk?