Database log file is full

[StPatrick]

I've got this error:

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?

 

[andyp]

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".

 

[andyp]

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.

 

[Yash]

What is your username?
This should have been done with the nightly backup.
We do the cleaning up manually

 

[StPatrick]

What is your username?
This should have been done with the nightly backup.
We do the cleaning up manually

I've PMed you the username now, Yash

 

[Yash]

We cleared it for you.

 

[StPatrick]

We cleared it for you.

Thank you Yash

 

[manodu]

Hi

I have the same problem with mi log file

Please help