|
Home > Archive > ASE Database forum > October 2005 > disable log for databaes in ASE ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
disable log for databaes in ASE ?
|
|
|
| is it possible to disable logging for database ? rather than from time to
time i will have to do "dump tran database with no_log" ? If i dont do
this, after heavy usage, my database will run out of space for log.
thank for feedback.
| |
| mpeppler@peppler.org 2005-10-27, 8:21 am |
| > is it possible to disable logging for database ? rather
> than from time to time i will have to do "dump tran
> database with no_log" ? If i dont do this, after heavy
> usage, my database will run out of space for log.
If you don't need the ability to recover via the log then
you need
to enable the "truncate log on checkpoint" option for your
database:
use master
go
sp_dboption <your db name>, 'trunc. log on checkpoint',
'true'
go
As an aside - you should only run "dump tran with no_log" if
you can't run the "with truncate_only" version.
Michael
|
|
|
|
|