Re: How do you turn off logginf in ODS?
Posted in 1997
In article <864636365.9162@dejanews.com>, miroslav.lorenc@ssa.co.uk
writes
>In article <JrP+I0y.jorget@delphi.com>,
> Jorge Torralba <jorget@delphi.com> wrote:
>>
>>
>> ontape -s -L 0 -N databasename>>
>> you may want to change your archive tape to /dev/null if you are not
>> interested in a real backup and are looking to speed up the archive.
>>
>
>You don`t need to do an archive when you are changing from database with
>transaction logging to no logged database.
>
>Use simply ontape -N database (you can change to No logging mode from
>onmonitor Logical Logs/Databases menu too).
>
>Archive is needed only to turn logging on.
>
True but I normally take a level 0 arhive anyway as a fallback
position in case whatever i am doing fail, since I don't have logging
rollback is not possible...also this could be just when a disk or
or memory (I've seen it happen) or power fails when you have no UPS...
More of a precaution then a necessity...
>ontape -s -L 0 -{U|B} database>
>> To turn logging back on replace the -N with a -B
>>
>> Jorge :)
>
>Regards,
>Miroslav Lorenc
>SSA Czech Republic
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
--
David Williams