Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disable Transaction Logging
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00195608
Message ID:
00195789
Views:
14
It's not possible to disable logging withing SQL Server. You can enable the use of non-logged functions, like WRITETEXT, but in general you cannot disable logging. Nor do you really want to. The information in the transaction log is used to restore the database to a stable state if the server were to prematurely go down (ie crash).

If you do not want to periodically backup the transaction log for recovery purposes, you can set the Truncate Log On Checkpoint database option. SQL Server will automatically remove terminated transactions (committed or rolled-back) from the log when the Checkpoint occurs (about once a minute).

HTH

-MIke
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform