Hi

I have a sybase database (Adaptive Server Enterprise/12.0.0.3/P/SWR)
which has the transaction log enabled - and thus bcp disabled.

I would like to reverse this to allow bcping.

Is it possible to do this intra-day (i.e. whilst users are actively in
the system) or does it require a server restart / single user ?

Similarly what are the constraints for turning the transaction log
back on again ?

Thanks
Chris

"Chris Marshall" <c_j_marshall (AT) hotmail (DOT) com> wrote


I think there may be some misunderstandings here.
First, the transaction log cannot be turned off.
Second, bcp cannot really be disabled.

Could you perhaps post more details as to what you're trying to do and what
goes wrong (preferably with the original error messages) ?

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of various Sybase books. New book (coming soon): "The
Complete Sybase Replication Server Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Rob Verschoor" <rob (AT) DO (DOT) NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote


Sorry - I guess I could have worded it better.
Is it safe to turn "select into/bulkcopy/pllsort" to true (and back to
false) whenever you wish ?

On Thu, 08 Jul 2004 01:03:36 -0700, Chris Marshall wrote:

Changing the setting of this option won't affect recoverability in any way.
It's only if you run a minimally logged operation (such as certain "alter
table" commands, or fast bcp in, for example) that the transaction dumps
will stop working and you'll have to do a full database dump.
The transaction dump command will tell you this, BTW.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote


Ah I get it now - thanks both of you for your help.

Cheers,
Chris