Disadvantage "trunc. log on chkpt."?

Hi NG
In a published db (transactional), anytime
the option "trunc. log on chkpt."( for fast BCP) is active.
I have set
<PublicationDatabaseName>', 'sync with backup', 'true'
<DisributionDatabaseName>', 'sync with backup', 'true'
for full recovery in desaster case.
Is it a problem?
BOL says, if sync with backup = true
then trunc. log on chkpt must be false!
How can I bypass this circumstance?
Stop Logreader and Distritask?
Regards,
Thomas
the same question
for option: 'select into/bulkcopy'
On Mon, 16 Aug 2004 09:16:47 GMT, tohas@.freenet.de (Thomas Hase)
wrote:

>Hi NG
>In a published db (transactional), anytime
>the option "trunc. log on chkpt."( for fast BCP) is active.
>I have set
><PublicationDatabaseName>', 'sync with backup', 'true'
><DisributionDatabaseName>', 'sync with backup', 'true'
>for full recovery in desaster case.
>Is it a problem?
>BOL says, if sync with backup = true
>then trunc. log on chkpt must be false!
>How can I bypass this circumstance?
>Stop Logreader and Distritask?
>Regards,
>Thomas
|||If you have to switch recovery models you are breaking the log chain. You
will have to change your recovery model back to full, backup your databases
(distribution and publication) and restore them on the subscriber with the
keep_replication switch.
Then start shipping the logs again.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:41227e0d.67962859@.news.t-online.de...
> the same question
> for option: 'select into/bulkcopy'
>
> On Mon, 16 Aug 2004 09:16:47 GMT, tohas@.freenet.de (Thomas Hase)
> wrote:
>

Disabled/turn off Transcation logging while performing BCP opratio

Hi,
I am doing BCP in particular database.I need to improve perfommace of BCP
opration.I found some article which provide way to minmize transcation
logging.
Please let me know how I completely disabled /turn off transaction logging
for optimized & higher performance.
Regards
Amit Samria
You can't completely turn off transaction logging but you can change your
database to use BULK logging, which works well with bcp. You can do this via
Enterprise Manager or with:
ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
Jacco Schalkwijk
SQL Server MVP
"Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> Hi,
> I am doing BCP in particular database.I need to improve perfommace of BCP
> opration.I found some article which provide way to minmize transcation
> logging.
> Please let me know how I completely disabled /turn off transaction
> logging
> for optimized & higher performance.
> Regards
> Amit Samria
>

Disabled/turn off Transcation logging while performing BCP opratio

Hi,
I am doing BCP in particular database.I need to improve perfommace of BCP
opration.I found some article which provide way to minmize transcation
logging.
Please let me know how I completely disabled /turn off transaction logging
for optimized & higher performance.
Regards
Amit SamriaYou can't completely turn off transaction logging but you can change your
database to use BULK logging, which works well with bcp. You can do this via
Enterprise Manager or with:
ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
--
Jacco Schalkwijk
SQL Server MVP
"Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> Hi,
> I am doing BCP in particular database.I need to improve perfommace of BCP
> opration.I found some article which provide way to minmize transcation
> logging.
> Please let me know how I completely disabled /turn off transaction
> logging
> for optimized & higher performance.
> Regards
> Amit Samria
>|||Hi Jacco,
I found in some article that a nonlogged bulk copy can be performed if
The database option select into/bulkcopy is set to true using sp_dboption.
Is above mentioned way same as setting recovery model using alter table.
Regards
Amit Samria
"Jacco Schalkwijk" wrote:
> You can't completely turn off transaction logging but you can change your
> database to use BULK logging, which works well with bcp. You can do this via
> Enterprise Manager or with:
> ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
> news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> > Hi,
> > I am doing BCP in particular database.I need to improve perfommace of BCP
> > opration.I found some article which provide way to minmize transcation
> > logging.
> > Please let me know how I completely disabled /turn off transaction
> > logging
> > for optimized & higher performance.
> >
> > Regards
> > Amit Samria
> >
> >
>
>|||Yes. Bulk-Logged recovery in SQL Server 2000 is similar to
setting select into/bulk copy to true in SQL Server 7. Some
operations will be minimally logged with this option or
recovery model.
-Sue
On Mon, 18 Oct 2004 04:19:02 -0700, "Amit Samria"
<AmitSamria@.discussions.microsoft.com> wrote:
>Hi Jacco,
>I found in some article that a nonlogged bulk copy can be performed if
>The database option select into/bulkcopy is set to true using sp_dboption.
>Is above mentioned way same as setting recovery model using alter table.
>Regards
>Amit Samria
>"Jacco Schalkwijk" wrote:
>> You can't completely turn off transaction logging but you can change your
>> database to use BULK logging, which works well with bcp. You can do this via
>> Enterprise Manager or with:
>> ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
>> --
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>> "Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
>> news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
>> > Hi,
>> > I am doing BCP in particular database.I need to improve perfommace of BCP
>> > opration.I found some article which provide way to minmize transcation
>> > logging.
>> > Please let me know how I completely disabled /turn off transaction
>> > logging
>> > for optimized & higher performance.
>> >
>> > Regards
>> > Amit Samria
>> >
>> >
>>

Disabled/turn off Transcation logging while performing BCP opratio

Hi,
I am doing BCP in particular database.I need to improve perfommace of BCP
opration.I found some article which provide way to minmize transcation
logging.
Please let me know how I completely disabled /turn off transaction logging
for optimized & higher performance.
Regards
Amit SamriaYou can't completely turn off transaction logging but you can change your
database to use BULK logging, which works well with bcp. You can do this via
Enterprise Manager or with:
ALTER DATABASE <db name> SET RECOVERY BULK_LOGGED
Jacco Schalkwijk
SQL Server MVP
"Amit Samria" <Amit Samria@.discussions.microsoft.com> wrote in message
news:33190FE5-07CB-43E0-9690-84152EE61503@.microsoft.com...
> Hi,
> I am doing BCP in particular database.I need to improve perfommace of BCP
> opration.I found some article which provide way to minmize transcation
> logging.
> Please let me know how I completely disabled /turn off transaction
> logging
> for optimized & higher performance.
> Regards
> Amit Samria
>