|
Home > Archive > ASE Database forum > April 2005 > How can I force Log to suspend or turn off Logging for a period of time?
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 |
How can I force Log to suspend or turn off Logging for a period of time?
|
|
| Robin Parsons 2005-04-20, 11:24 am |
| How can I turn off logging during a load, if desired?
Thanks in advance,
Robin
| |
| Jeffrey R. Garbus 2005-04-20, 11:24 am |
| You can't.
The closest you can come is to turn on 'select into / bulk copy' and drop
all the indexes. Then, you only log page allocations during bcp in or select
into.
Jeff
<Robin Parsons> wrote in message news:42667cb7.3c53.1681692777@sybase.com...
> How can I turn off logging during a load, if desired?
>
> Thanks in advance,
> Robin
| |
| Robin Parsons 2005-04-20, 11:24 am |
| Thanks, Jeff. What is the syntax to turn on 'select into /
bulk copy'?
> You can't.
>
> The closest you can come is to turn on 'select into / bulk
> copy' and drop all the indexes. Then, you only log page
> allocations during bcp in or select into.
>
> Jeff
> <Robin Parsons> wrote in message
> turn off logging during a load, if desired? >
>
>
| |
| Jeffrey R. Garbus 2005-04-20, 1:24 pm |
| use master
go
sp_dboption YOURDBNAME,'select into',true
go
use YOURDBNAME
go
checkpoint
go
enjoy!
Jeff
<Robin Parsons> wrote in message news:42667f9e.74e8.1681692777@sybase.com...[color=darkred]
> Thanks, Jeff. What is the syntax to turn on 'select into /
> bulk copy'?
>
| |
| Mark K 2005-04-21, 9:24 am |
| In 12.5.1 and later, sp_dboption will automatically run the checkpoint so
the "use YOURDBNAME" and "checkpoint" are no longer necessary.
Mark Kusma
http://www.sybase.com/support/about...t/otherservices
"Jeffrey R. Garbus" <jeff@soaringeagle.biz> wrote in message
news:42669145$1@foru
ms-2-dub...
> use master
> go
> sp_dboption YOURDBNAME,'select into',true
> go
> use YOURDBNAME
> go
> checkpoint
> go
>
>
> enjoy!
>
> Jeff
> <Robin Parsons> wrote in message
news:42667f9e.74e8.1681692777@sybase.com...
>
>
|
|
|
|
|