Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
 Posted - 2009-10-08 : 04:14:34
|
| Hi I suddenly got such error when I try to browse my web application.Can anyone pls tell me what is the reason of below error msg and how to resolve ?The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Thanks in advance ! |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-10-08 : 04:24:41
|
| Check the following steps for that issue……1. Take Backup db2. shrink db3. check db integrity4. re-organize index5. update statistics6. Set recovery model to simple -------------------------R... |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-08 : 04:30:42
|
quote:
Originally posted by rajdaksha1. Take Backup db
Not going to do anything for the log sizequote:
2. shrink db
The log won't shrink cause it's full. Shrinking the data files is a bad idea, causes fragmentationquote:
3. check db integrity
Not necessary herequote:
4. re-organize index
Will fail because the log is fullquote:
5. update statistics
Not going to do anything for the logquote:
6. Set recovery model to simple
Will fix the log problem, but will leave the DB in a state where point-in-time recovery cannot be done. If the DB fails and the last full backup is a day ago, that's a day's work gone.--Gail ShawSQL Server MVP |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-08 : 04:31:28
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]If you still have questions on what to do after reading it, please ask.--Gail ShawSQL Server MVP |
|
|
|
kwikwisi
Constraint Violating Yak Guru
283 Posts |
Posted - 2009-10-08 : 04:34:21
|
| It solved once I changed the recovery model to simple. Thanks. |
|
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-10-08 : 04:34:39
|
| Hi MonsterNice to learn from you....i will do analysis for what u have mentioned..Please explain the solution...at least we are learn from you...Thanks-------------------------R... |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-08 : 05:26:16
|
quote:
Originally posted by kwikwisi
It solved once I changed the recovery model to simple.
You are aware that simple recovery does not allow point-in-time restores. If a full backup runs at 10pm and something happens to the database next day at 6pm, then you will have lost a full day's work. Is that acceptable?--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Db Error