SQL SERVER – Solution – Log File Very Large – Log Full

I have been receiving following question again and again either through email or through comments on this blog.

My log file is too big, what should I do?

Answer to this question is in three steps.

  • Backup the log file to any device.
  • Truncate the log file.
  • Shrink the log file.

I have previously written two article about this issue. Refer them for additional information and details.

SQL SERVER – Shrinking Truncate Log File – Log Full(Script)

SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2(Management Studio)

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Backup and Restore, SQL Data Storage, SQL Log
Previous Post
SQLAuthority News – Top 10 Tips for Successful Software Outsourcing
Next Post
SQL SERVER – T-SQL Script to Find Details About TempDB Information

Related Posts

5 Comments. Leave new

  • How to shrink the database not the the log file

    Best regards
    Saudi Arabia

  • Chetan Patel
    July 21, 2009 4:13 pm

    Hi My Database log file is large so finding a data from database it is very slow the result of output getting.
    so what i should do?

    And second problem is whenever multiple user upload data on that server that time web site is not running i.e. error is generate server unavailable application.so what is the reason…?

  • MohammadReza
    July 22, 2009 8:52 am

    how can we backup one datafile and restore it in another server ?
    is it possible?

    • To MohammadReza:
      Yes it is possible, just restore it as you would in any normal database. Just make sure you do have a database to restore it to.

  • Hi,

    Can you please suggest me on the below.
    I want to set up the notification whenever my t-log is full.
    can we use a script for automatically shrinking the log file.


Leave a Reply