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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2006-05-25 : 13:58:04
|
| can the transaction log be filled.?lets say i deleted millions of rows. does it get filled? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-05-25 : 14:01:46
|
| yes and yes.that is why you should schedule regular tlog backups when your database is in full or bulk logging mode. If you are in simple logging mode, then the tlog is truncated at checkpoint. Running in simple logging means that you will not be able to perform a point in time recovery.For more information on how this works, just read books online.-ec |
 |
|
|
|
|
|
can the transaction log be filled.?