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.
Tags:SQl,SQL 2005,Ms sql,Sql 2008,DB,DBA,SQl error,Trasaction Log.
I am in fact glad to read this web site posts
which contains tons of helpful information, thanks for providing
these kinds of data.
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
You can directly suscribe from the website below the main page.
Hi, Neat post. There’s an issue with your site in web explorer, may test this?
IE nonetheless is the marketplace leader and a huge element of people will omit your fantastic
writing because of this problem.
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?