How To Empty Log File of SQL DATA

It may be sound so strange, and you will say, What are you talking about?

One of our customers had a case that when he post any transaction, it didn’t post and show an error that he can’t post due to SQL Log error.

This error occurred due to the size of the Logfile in SQL Database is increasing more than the capacity of the Hard Disk Drive, and the Drive is Full, therefore any transaction can’t be posted because the system can’t write theses transaction in the Log File.

So the first logical sequence to resolve this issue is to move the log file as a backup on a separate drive which has available drive space, so you can refer to it again.

Second, you should empty this file from the full used drive, so the users can post their transactions.

And here is how you can empty the log file from SQL Database.

1- From SQL Server Database, Right-Click on the current used Database & then select Properties.

2-  From Options, select “Recovery Model” as “Simple”

If you find it is default as “Full”, Change it to “Simple”, so it will not duplicate the size of the Log File.

3- Then, Go to “Files“.

From “File Type“, Select “LOG” Line.

4- From “Initial Size“, enter the size you want to apply on the current database.

To empty the file size you may enter value 0 or 100 MB, so you will empty the log file with the current value you type in this field.

5- Click “Apply” or “OK” Button.

6- After finishing empty your Log file, make sure you return the value of the “Recovery Model” to “Full“.

That’s all. See you in the next post.