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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-05-03 : 14:08:37
|
| I recieved this message while my database was in simple recovery:The log file for database 'MyDB' is full. Back up the transaction log for the database to free up some log space..I thought the transaction log isn't utilized while in simple recovery. Why did I recieve this message?Thanks,Ray |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-03 : 17:44:52
|
| It is still utilized, but when the transaction completes, it'll clear itself out. So you had a very large query that ran and you ran out of disk space before it was committed.Tara |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-05-04 : 08:34:40
|
| Thanks Tara! You're awesome! After reading your post, I found this in BOL regarding transaction log architecture and long running transactions: "The log may grow very large because the log cannot be truncated past the MinLSN. This happens even if the database is using the simple recovery model, in which the transaction log is normally truncated on each automatic checkpoint."- ray |
|
|
|
|
|
|
transaction log full in simple recovery