SUPPORT >> SQL SERVER >> TRUNCATE SQL SERVER LOG FILE
What do I do when I get "the log file is full" error?
A SQL database contains a data file and a log file. The log file stores information about changes that are made to your database. The size of the log file is based on the SQL plan type. If the log file fills then no changes can be made and you will receive an error message saying the log file is full.
To clear out the log file, please follow these steps:
- Log in to your control panel at controlpanel.zighead.com.
- Click on Database Administration and select SQL Server Administration.
- Click on Truncate Log next to your database.
|