SQL Tutorials

The transaction log for database ‘mydb’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

The transaction log for database ‘mydb’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Issue:

When i try to take the database backup or modify any values in the database It is giving the Log error mention in the below.

The transaction log for database ‘mydb’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Solution:

– Log in to the database.

– Before do this process take the backup copy of .mdf and .ldf files.

– Right click on the database and click on properties.

– Select Files option.

– In right side window it will show the Database files.

– In that select Autogrowth option and click on the browse tab.

– New window will apear with change the autogrowth size.

– Change the option from Restricted growth to Unrestricted File Growth .

– Click on ok and save the option.Now you can take the backup and modify the values.
Transaction log error

Tags:SQl,SQL 2005,Ms sql,Sql 2008,DB,DBA,SQl error,Trasaction Log.

About the author

admin

5 Comments

Click here to post a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

  • Fantastic beat ! I would like to apprentice while you amend
    your website, how could i subscribe for a blog site?
    The account aided me a acceptable deal. I had been a
    little bit acquainted of this your broadcast offered bright clear concept

  • I am really enjoying the theme/design of your site.
    Do you ever run into any internet browser compatibility problems?
    A small number of my blog visitors have complained about my site
    not working correctly in Explorer but looks great in Opera.
    Do you have any recommendations to help fix this issue?