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 (http://blog.SQLAuthority.com)

6 thoughts on “SQL SERVER – Solution – Log File Very Large – Log Full

  1. 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…?

    Like

    • 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.

      Like

  2. 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.

    Like

  3. Pingback: SQL SERVER – Weekly Series – Memory Lane – #008 « SQL Server Journey with SQL Authority

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s