April 6, 2010 at 9:08 am
Msg 9002, Level 17, State 2, Line 8
The transaction log for database 'FTTPReports' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
any suggestions on this on solution
April 6, 2010 at 9:32 am
What does the wait data say?
The usual causes are either the disk is full, or the log file has a maximum size and has reached it.
The usual solutions are run a log backup and a checkpoint, and free up some space in the log, then do what's needed if the disk is full.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 6, 2010 at 9:34 am
Post the results of the following:
select name as databasename, log_reuse_wait_desc from sys.databases
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply