Database log file is full

Customer Support Database Support
1

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? :slight_smile:

2

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 :slight_smile: ), then it will be freed after “some time”.

3

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.

4

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

5

[QUOTE=Yash]
What is your username?
This should have been done with the nightly backup.
We do the cleaning up manually
[/QUOTE]

I’ve PMed you the username now, Yash

6

We cleared it for you.

7

[QUOTE=Yash]
We cleared it for you.
[/QUOTE]

Thank you Yash :slight_smile:

8

Hi

I have the same problem with mi log file

Please help