Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

temporary remove secondary truncation point.

9 posts in General Discussion Last posting was on 2011-08-12 15:13:03.0Z
Luc Van der Veurst Posted on 2011-08-09 13:38:10.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.rep-server
Subject: temporary remove secondary truncation point.
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e413842$1@forums-1-dub>
Date: 9 Aug 2011 06:38:10 -0700
X-Trace: forums-1-dub 1312897090 10.22.241.152 (9 Aug 2011 06:38:10 -0700)
X-Original-Trace: 9 Aug 2011 06:38:10 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9015
Article PK: 870204

Hello,

I have to load data into a database that has a rep agent,
the data should not be replicated and there is no other activity in the
database.

I want to avoid delay in loading the data due to the secondary truncation
point moving forward slower than the primary truncation point.

My idea is to :

- execute in <db> : sp_stop_rep_agent <db>
- execute in <db> : settrunc('ltm', 'ignore')
- load the data
- execute in <db> : settrunc('ltm', 'valid')
- execute in <db> : settrunc('ltm', 'end')
- execute in rssd db : rs_zeroltm <server>, <db>
- execute in <db> : sp_start_rep_agent <db>

My first idea was to start with disabling the rep agent with
sp_config_rep_agent
but then I read that this removes the rep agent configuration from the
database
and I want to preserve the rep agent configuration settings.

Would this be ok ?

Thanks,
Luc.


Luc Van der Veurst Posted on 2011-08-09 13:47:58.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.rep-server
References: <4e413842$1@forums-1-dub>
Subject: Re: temporary remove secondary truncation point.
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e413a8e$1@forums-1-dub>
Date: 9 Aug 2011 06:47:58 -0700
X-Trace: forums-1-dub 1312897678 10.22.241.152 (9 Aug 2011 06:47:58 -0700)
X-Original-Trace: 9 Aug 2011 06:47:58 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9016
Article PK: 870181

settrunc => dbcc settrunc

"Luc Van der Veurst" <dba_azvub@hotmail.com> wrote in message
news:4e413842$1@forums-1-dub...
> Hello,
>
> I have to load data into a database that has a rep agent,
> the data should not be replicated and there is no other activity in the
> database.
>
> I want to avoid delay in loading the data due to the secondary truncation
> point moving forward slower than the primary truncation point.
>
> My idea is to :
>
> - execute in <db> : sp_stop_rep_agent <db>
> - execute in <db> : settrunc('ltm', 'ignore')
> - load the data
> - execute in <db> : settrunc('ltm', 'valid')
> - execute in <db> : settrunc('ltm', 'end')
> - execute in rssd db : rs_zeroltm <server>, <db>
> - execute in <db> : sp_start_rep_agent <db>
>
> My first idea was to start with disabling the rep agent with
> sp_config_rep_agent
> but then I read that this removes the rep agent configuration from the
> database
> and I want to preserve the rep agent configuration settings.
>
> Would this be ok ?
>
> Thanks,
> Luc.
>
>
>


sybanva Posted on 2011-08-09 14:11:47.0Z
Sender: 6ba4.4e41398b.1804289383@sybase.com
From: sybanva
Newsgroups: sybase.public.rep-server
Subject: Re: temporary remove secondary truncation point.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e414023.6e0a.1681692777@sybase.com>
References: <4e413a8e$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Aug 2011 07:11:47 -0700
X-Trace: forums-1-dub 1312899107 10.22.241.41 (9 Aug 2011 07:11:47 -0700)
X-Original-Trace: 9 Aug 2011 07:11:47 -0700, 10.22.241.41
Lines: 57
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9018
Article PK: 870188

Hi Luc,
As per your steps, if you are loading the database with prod
dump then it would clear the rep agent information from
sysattributes tabel of the target db ( If your prod env also
has replication setup, then after load database ,it would
have prod replication config info).

So I guess,you need to disable the rep agent config from
target before load , after that you again need to enable it
after load.

Conceptually, rest other steps are looking fine.

Any comments most welcome!

> settrunc => dbcc settrunc
>
> "Luc Van der Veurst" <dba_azvub@hotmail.com> wrote in
> message news:4e413842$1@forums-1-dub...
> > Hello,
> >
> > I have to load data into a database that has a rep agent
> > , the data should not be replicated and there is no
> > other activity in the database.
> >
> > I want to avoid delay in loading the data due to the
> > secondary truncation point moving forward slower than
> the primary truncation point. >
> > My idea is to :
> >
> > - execute in <db> : sp_stop_rep_agent <db>
> > - execute in <db> : settrunc('ltm', 'ignore')
> > - load the data
> > - execute in <db> : settrunc('ltm', 'valid')
> > - execute in <db> : settrunc('ltm', 'end')
> > - execute in rssd db : rs_zeroltm <server>, <db>
> > - execute in <db> : sp_start_rep_agent <db>
> >
> > My first idea was to start with disabling the rep agent
> > with sp_config_rep_agent
> > but then I read that this removes the rep agent
> > configuration from the database
> > and I want to preserve the rep agent configuration
> settings. >
> > Would this be ok ?
> >
> > Thanks,
> > Luc.
> >
> >
> >
>
>


Luc Van der Veurst Posted on 2011-08-09 20:26:55.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.rep-server
References: <4e413a8e$1@forums-1-dub> <4e414023.6e0a.1681692777@sybase.com>
Subject: Re: temporary remove secondary truncation point.
Lines: 73
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Original
X-Forwarded: by - (DeleGate/5.8.7)
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e41980f$1@forums-1-dub>
Date: 9 Aug 2011 13:26:55 -0700
X-Trace: forums-1-dub 1312921615 10.22.241.152 (9 Aug 2011 13:26:55 -0700)
X-Original-Trace: 9 Aug 2011 13:26:55 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9020
Article PK: 870191


<sybanva> wrote in message news:4e414023.6e0a.1681692777@sybase.com...
> Hi Luc,
> As per your steps, if you are loading the database with prod
> dump then it would clear the rep agent information from
> sysattributes tabel of the target db ( If your prod env also
> has replication setup, then after load database ,it would
> have prod replication config info).
>
> So I guess,you need to disable the rep agent config from
> target before load , after that you again need to enable it
> after load.

That's right, if you load a database into another system, that also
includes replication, you need to update the replication configuration
after the load before starting the rep agent.

Luc.






>
> Conceptually, rest other steps are looking fine.
>
> Any comments most welcome!
>
>
>
>
>
>> settrunc => dbcc settrunc
>>
>> "Luc Van der Veurst" <dba_azvub@hotmail.com> wrote in
>> message news:4e413842$1@forums-1-dub...
>> > Hello,
>> >
>> > I have to load data into a database that has a rep agent
>> > , the data should not be replicated and there is no
>> > other activity in the database.
>> >
>> > I want to avoid delay in loading the data due to the
>> > secondary truncation point moving forward slower than
>> the primary truncation point. >
>> > My idea is to :
>> >
>> > - execute in <db> : sp_stop_rep_agent <db>
>> > - execute in <db> : settrunc('ltm', 'ignore')
>> > - load the data
>> > - execute in <db> : settrunc('ltm', 'valid')
>> > - execute in <db> : settrunc('ltm', 'end')
>> > - execute in rssd db : rs_zeroltm <server>, <db>
>> > - execute in <db> : sp_start_rep_agent <db>
>> >
>> > My first idea was to start with disabling the rep agent
>> > with sp_config_rep_agent
>> > but then I read that this removes the rep agent
>> > configuration from the database
>> > and I want to preserve the rep agent configuration
>> settings. >
>> > Would this be ok ?
>> >
>> > Thanks,
>> > Luc.
>> >
>> >
>> >
>>
>>


Rob V [ Sybase ] Posted on 2011-08-09 15:02:11.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: temporary remove secondary truncation point.
References: <4e413842$1@forums-1-dub>
In-Reply-To: <4e413842$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e414bf3@forums-1-dub>
Date: 9 Aug 2011 08:02:11 -0700
X-Trace: forums-1-dub 1312902131 10.22.241.152 (9 Aug 2011 08:02:11 -0700)
X-Original-Trace: 9 Aug 2011 08:02:11 -0700, vip152.sybase.com
Lines: 61
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9019
Article PK: 870185


On 09-Aug-2011 15:38, Luc Van der Veurst wrote:
> Hello,
>
> I have to load data into a database that has a rep agent,
> the data should not be replicated and there is no other activity in the
> database.
>
> I want to avoid delay in loading the data due to the secondary truncation
> point moving forward slower than the primary truncation point.
>
> My idea is to :
>
> - execute in<db> : sp_stop_rep_agent<db>
> - execute in<db> : settrunc('ltm', 'ignore')
> - load the data
> - execute in<db> : settrunc('ltm', 'valid')
> - execute in<db> : settrunc('ltm', 'end')
> - execute in rssd db : rs_zeroltm<server>,<db>
> - execute in<db> : sp_start_rep_agent<db>
>
> My first idea was to start with disabling the rep agent with
> sp_config_rep_agent
> but then I read that this removes the rep agent configuration from the
> database
> and I want to preserve the rep agent configuration settings.
>
> Would this be ok ?
>
> Thanks,
> Luc.
>
>
>

Hi Luc,

When you say 'load the data' I guess you're doing a BCP-in or something?
Your approach should then work. But why not truncate the log first
before re-establishing the trunc point? It'll save you running
"settrunc('ltm', 'end')".

--

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

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

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


Luc Van der Veurst Posted on 2011-08-09 20:35:50.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.rep-server
References: <4e413842$1@forums-1-dub> <4e414bf3@forums-1-dub>
Subject: Re: temporary remove secondary truncation point.
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-Forwarded: by - (DeleGate/5.8.7)
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e419a26$1@forums-1-dub>
Date: 9 Aug 2011 13:35:50 -0700
X-Trace: forums-1-dub 1312922150 10.22.241.152 (9 Aug 2011 13:35:50 -0700)
X-Original-Trace: 9 Aug 2011 13:35:50 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9021
Article PK: 870186

Hi Rob,

"Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
message news:4e414bf3@forums-1-dub...
> On 09-Aug-2011 15:38, Luc Van der Veurst wrote:
>> Hello,
>>
>> I have to load data into a database that has a rep agent,
>> the data should not be replicated and there is no other activity in the
>> database.
>>
>> I want to avoid delay in loading the data due to the secondary truncation
>> point moving forward slower than the primary truncation point.
>>
>> My idea is to :
>>
>> - execute in<db> : sp_stop_rep_agent<db>
>> - execute in<db> : settrunc('ltm', 'ignore')
>> - load the data
>> - execute in<db> : settrunc('ltm', 'valid')
>> - execute in<db> : settrunc('ltm', 'end')
>> - execute in rssd db : rs_zeroltm<server>,<db>
>> - execute in<db> : sp_start_rep_agent<db>
>>
>> My first idea was to start with disabling the rep agent with
>> sp_config_rep_agent
>> but then I read that this removes the rep agent configuration from the
>> database
>> and I want to preserve the rep agent configuration settings.
>>
>> Would this be ok ?
>>
>> Thanks,
>> Luc.
>>
>>
>>
>
> Hi Luc,
>
> When you say 'load the data' I guess you're doing a BCP-in or something?

Yep. I have 2 dataservers with bi-directional database replication between
them
(one active, one standby) and I want to add a 3rd server with bi-directional
database
replication between each pair of servers. The 2 servers are ase 12.5.4 on
solaris sparc
with 2K pages and the 3rd server is ase 15.5 on solaris intel with 4K pages.
So I'm using bcp to copy data from the standby server to the new server
while
replication from the active server is suspended.

> Your approach should then work. But why not truncate the log first before
> re-establishing the trunc point? It'll save you running "settrunc('ltm',
> 'end')".

OK, I'll do that. Does it mean that settrunc('ltm', 'end') is an expensive
operation ?
I have trunc log on checkpoint on during bcp load, so it will probably not
make
much difference in this case.

Thanks,
Luc.


Rob V [ Sybase ] Posted on 2011-08-09 23:37:19.0Z
From: "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: temporary remove secondary truncation point.
References: <4e413842$1@forums-1-dub> <4e414bf3@forums-1-dub> <4e419a26$1@forums-1-dub>
In-Reply-To: <4e419a26$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e41c4af$1@forums-1-dub>
Date: 9 Aug 2011 16:37:19 -0700
X-Trace: forums-1-dub 1312933039 10.22.241.152 (9 Aug 2011 16:37:19 -0700)
X-Original-Trace: 9 Aug 2011 16:37:19 -0700, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9022
Article PK: 870187


On 09-Aug-2011 22:35, Luc Van der Veurst wrote:
> OK, I'll do that. Does it mean that settrunc('ltm', 'end') is an expensive
> operation ?
> I have trunc log on checkpoint on during bcp load, so it will probably not
> make much difference in this case.
>
> Thanks,
> Luc.
>
>
>

No, but it saves you a statement. I agree that if you have trunc log on
checkpoint enabled, it will not matter much.

--

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

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

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


Manish Negandhi [TeamSybase] Posted on 2011-08-10 14:19:46.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.rep-server
References: <4e413842$1@forums-1-dub> <4e414bf3@forums-1-dub> <4e419a26$1@forums-1-dub>
Subject: Re: temporary remove secondary truncation point.
Lines: 83
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e429382$1@forums-1-dub>
Date: 10 Aug 2011 07:19:46 -0700
X-Trace: forums-1-dub 1312985986 10.22.241.152 (10 Aug 2011 07:19:46 -0700)
X-Original-Trace: 10 Aug 2011 07:19:46 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9024
Article PK: 870190


"Luc Van der Veurst" <dba_azvub@hotmail.com> wrote in message
news:4e419a26$1@forums-1-dub...
> Hi Rob,
>
> "Rob V [ Sybase ]" <rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote in
> message news:4e414bf3@forums-1-dub...
>> On 09-Aug-2011 15:38, Luc Van der Veurst wrote:
>>> Hello,
>>>
>>> I have to load data into a database that has a rep agent,
>>> the data should not be replicated and there is no other activity in the
>>> database.
>>>
>>> I want to avoid delay in loading the data due to the secondary
>>> truncation
>>> point moving forward slower than the primary truncation point.
>>>
>>> My idea is to :
>>>
>>> - execute in<db> : sp_stop_rep_agent<db>
>>> - execute in<db> : settrunc('ltm', 'ignore')
>>> - load the data
>>> - execute in<db> : settrunc('ltm', 'valid')
>>> - execute in<db> : settrunc('ltm', 'end')
>>> - execute in rssd db : rs_zeroltm<server>,<db>
>>> - execute in<db> : sp_start_rep_agent<db>
>>>
>>> My first idea was to start with disabling the rep agent with
>>> sp_config_rep_agent
>>> but then I read that this removes the rep agent configuration from the
>>> database
>>> and I want to preserve the rep agent configuration settings.
>>>
>>> Would this be ok ?
>>>
>>> Thanks,
>>> Luc.
>>>
>>>
>>>
>>
>> Hi Luc,
>>
>> When you say 'load the data' I guess you're doing a BCP-in or something?
>
> Yep. I have 2 dataservers with bi-directional database replication between
> them
> (one active, one standby) and I want to add a 3rd server with
> bi-directional database
> replication between each pair of servers. The 2 servers are ase 12.5.4 on
> solaris sparc
> with 2K pages and the 3rd server is ase 15.5 on solaris intel with 4K
> pages.
> So I'm using bcp to copy data from the standby server to the new server
> while
> replication from the active server is suspended.
>
>> Your approach should then work. But why not truncate the log first before
>> re-establishing the trunc point? It'll save you running "settrunc('ltm',
>> 'end')".
>
> OK, I'll do that. Does it mean that settrunc('ltm', 'end') is an expensive
> operation ?
> I have trunc log on checkpoint on during bcp load, so it will probably not
> make
> much difference in this case.
>
> Thanks,
> Luc.

Luc,

How about using maint_user to bcp the data in so that nothing gets
replicated and hence avoiding any additional task to disable replication
...?

-HTH
Manish Negandhi
[TeamSybase]


Luc Van der Veurst Posted on 2011-08-12 15:13:03.0Z
From: "Luc Van der Veurst" <dba_azvub@hotmail.com>
Newsgroups: sybase.public.rep-server
References: <4e413842$1@forums-1-dub> <4e414bf3@forums-1-dub> <4e419a26$1@forums-1-dub> <4e429382$1@forums-1-dub>
Subject: Re: temporary remove secondary truncation point.
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Response
X-Forwarded: by - (DeleGate/5.8.7)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e4542ff$1@forums-1-dub>
Date: 12 Aug 2011 08:13:03 -0700
X-Trace: forums-1-dub 1313161983 10.22.241.152 (12 Aug 2011 08:13:03 -0700)
X-Original-Trace: 12 Aug 2011 08:13:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9029
Article PK: 870195

"Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com> wrote in
message news:4e429382$1@forums-1-dub...

> How about using maint_user to bcp the data in so that nothing gets
> replicated and hence avoiding any additional task to disable replication
> ...?

I want to avoid that bcp-ing the data in causes log-problems that delay the
copy. Using the maintenance user would send all data to the repserver
(where it's ignored) and would fill up my stable queues and eventually the
log of the database because the secondary truncation point would stop
moving.

There are some other options: setting replication off on the connection
would
avoid sending the data to the replication server. In that case, I see
differences
of 5 minutes between the truncation and secondary truncation point.
So this option doesn't seem to cause log suspend situations.
(i don't know how much work the rep agent would be doing that would
slow down the bcp, though).

Since I don't have subscriptions to the data yet, another option is to
define the database
as passive instead of active in the replication server, but then I have to
see how
to make it an active database after loading the data. In any case, this
would
be an additional task as well.

And the additional tasks to disable/enable replication server are scripted,
it's
not that much effort :).

Luc.