I just altered a table on my large SQL server 2000 database and now the database has been offline for ages and the hard drive as run out of space because of the transaction log size.
What can I do! Enterprise manager has frozen me out completely and theres nothing else I can delete to free up space whist this completes.
I've not received any kind of warning and the HD is still being accessed by SQLserver.
Do you think this will eventually complete Should I stop the SQL service. HELP
What can I do! Enterprise manager has frozen me out completely and theres nothing else I can delete to free up space whist this completes.
I've not received any kind of warning and the HD is still being accessed by SQLserver.
Do you think this will eventually complete Should I stop the SQL service. HELP
URGENT - Run out of HD space whilst rebuilding an index