Technical Fixes
RSS icon Email icon Home icon
  • SQL – The Log File Is Full

    Posted on May 19th, 2009 Matt Parkinson No comments

    When backing up a a SQL database with Symantec Backup Exec I was seeing the error “The log file for database is full. Back up the transaction log for the database to free up some log space.” With backup exec to fix this you can run a backup of the SQL database and under the SQL options set the “Backup method for databases” to “LOG – Back Up Transaction Log.” However you can also clear this error by using the Microsoft SQL Query Analyzer and running the following query:

    backup log db_name with truncate_only
    go
    dbcc shrinkfile (db_name_log,0)
    go

    Leave a reply