Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Transaction log shutoff
0 views
Skip to first unread message
jonowens
Oct 3, 2008, 11:09:56 AM10/3/08
to
Is there a command to temporarily suspend writing to a
transaction log? We would like to shut that off while a
certain program is being run since the log grows excessively
when that particular program is executed. Thanks.
transaction log? We would like to shut that off while a
certain program is being run since the log grows excessively
when that particular program is executed. Thanks.
Unknown
Oct 3, 2008, 3:53:32 PM10/3/08
to
The engine has a -b switch if that is what you are looking for.
Care must be taken when using that ... you can break the
database's ability to recover, synchronize or replicate so
taking extra backups is usually recommended.
<Jon Owens> wrote in message news:48e635c4.76c...@sybase.com...
R. Pods
Oct 6, 2008, 6:06:12 AM10/6/08
to
... but you'll have to stop and restart the engine for the switch to be
active, and the same thing again to reverse the change.
active, and the same thing again to reverse the change.
Unknown
Oct 6, 2008, 9:51:58 AM10/6/08
to
> ... but you'll have to stop and restart the engine for the switch to be
> active, and the same thing again to reverse the change.
> active, and the same thing again to reverse the change.
Yes.
>> Care must be taken when using that ... you can break the
>> database's ability to recover, synchronize or replicate so
>> taking extra backups is usually recommended.
Yes. But then why would you not want to log if you are
concerned about that.
> ... alternatives? ...
Depending upon what you must achieve you could consider
doing things via 'load table'/'truncate table' and working only
with temporary tables.
"R. Pods" <r.p...@gmx.net> wrote in message news:48e9e314$1@forums-1-dub...
0 new messages