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 |
|
g_r_a_robinson
Starting Member
45 Posts |
 Posted - 2004-02-09 : 18:28:42
|
| How do i go about controlling the extent of what output to my transaction log. I've noticed that the size gets quite big and I need the extra diskspace. Can it be turned off and if so how, even better if i were able to determine whats recorded. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-09 : 21:14:29
|
| You can not turn off the transaction log. But you can change your recovery model to SIMPLE or BULK-LOGGED if it is appropriate. Have a look at the 3 different recovery models in SQL Server Books Online.Tara |
 |
|
|
|
|
|
managing the transaction log