Database log file is full

StPatrick

Perch
I've got this error:
Code:
The log file for database 'StpWorksMain' is full. 
Back up the transaction log for the database to free up some log space
But how do I actually free it? :)
 
Good question. Since you're not a member of db_backupoperator or db_owner, you can't use DBCC SHRINKDATABASE or BACKUP. I just hope the SQL Server is configured to truncate the log on checkpoints by default (you can't change this option yourself too :) ), then it will be freed after "some time".
 
One solution that I can think of is to perform A LOT of small operations like inserting or deleting a record. This should free some space in the log.
 
What is your username?
This should have been done with the nightly backup.
We do the cleaning up manually
 
Back
Top