suspend replication for tables in warm-standby
Is it possible for me to suspend replication for a subset of tables in a
warm-standby environment? I am running 11.5.1 rep server and 11.9.2 ASE
server. The problem is the query is done by the application and we don't
want that data to be replicated to the standby server. Since it is done
by the apps, we cannot set replication off for that session. Is there a
way to do this?
I don't think so. The workaround could be, create a new db and move these
table to new db. Create view in db 1 to this new db.
You are done. No changes to the application, no re...Warm Standby and Specific table replication
Can I have my primary database being replicated as to a
'warm standby' and also replicate a subset of tables to
Yes. However, if you only did a sp_reptostandby in the db, you will
have to additionally do a sp_setreptable on the tables you want as well.
> Can I have my primary database being replicated as to a
> 'warm standby' and also replicate a subset of tables to
> another replicate?
Additionaly, in RS 12.6, you can actually use the config setting
'r...Warm Standby Setting Up Table not to Replicate
What is it that in a warm standby setup even if I set a table not replicate
its still replicating? Any config I forgot to change?
"chito" <email@example.com> wrote in message
> What is it that in a warm standby setup even if I set a table not
> its still replicating? Any config I forgot to change?
Depends how you configured your standby. If you used
"sp_reptostandby", the entire database will be replicated, without a
need for marking individu...mixing table replication and warm standby
Is it possible to create a warm-standby replication from an
ASE already having table replication ? I have a central ASE
database replicating bi-directionnally with other ASEs in
satelite offices. RS version is 12.5. I would like to setup
a warm standby from this central ASE database to another
location for disaster recovery. Is it possible ? Is it like
a classic warm standby setup or is there a special way of
setting it ?
> Is it possible to create a warm-standby replication from an
> ASE already having table replication ? I h...Table Rep Defs and Warm Standby
I'm creating some table rep defs for my warm standby application. (ASE
12.5.2 & RS 12.6)
Do I need to subscribe to the rep defs, or do they just get used
The reason I ask is that it doesn't really look as if my definitions are
being used - or I've created the definitions incorrectly.
CREATE TABLE dbo.TestTextRep
id numeric(8,0) IDENTITY,
thedescription varchar(50) NULL,
thetext text NULL,
id is PK.
create replication definition TestTextRep_TblDef
with primary at hc_log...Warm Standby with Replication Server/Oracle
Is it possible to set up a pair of Oracle databases, one as the warm
standby of the other, utilizing Sybase Rep Server? Has anyone done that
in a production env.? I would like to hear opinions from the experts.
...warm standby without Rep Server
I would like to replicate my OLTP database to a DSS database, but don't
have money in the budget for Replication Server. Does anyone have a
relatively easy way to use transaction logs to keep a reporting database
syncronized with a production database?
> I would like to replicate my OLTP database to a DSS database, but don't
> have money in the budget for Replication Server. Does anyone have a
> relatively easy way to use transaction logs to keep a reporting database
> syncronized with a production database?
Sure, just write scripts to dump transaction lo...How to Exclude singe table from Replication Warm standby
I have a question regarding Sybase Replication Server.
(Could not find proper newsgroup for my question.)
I have a warm standby replication between 2 ASE(15.0.2).
the Rep is 15.0.1.
Can i "check-out" single table from the warm standby
I want that "all" the database will replication expect one
what is the command to exclude the table from replication?
sp_setreplicate <my table>, false
The message says:
The replication status for <my table>' is already set to
false. Replication status for '<my table&g...Set warm standby using replication server
Is there paper out there talk about setting up warm standby using
Thanks in advance.
Y. M. Zhang wrote:
> Is there paper out there talk about setting up warm standby using
> replication server?
> Thanks in advance.
Take a look at the Replication Server Design Guide which can be found
from the Sybooks under the Sybase Web site. Also the Fast Track to
Replication Server Administration class from Sybase discusses great
details about warm standby.
Hope this help!
I have some notes that I wrote on the order in which to perform steps...steps in shutting down rep server with warm standby
I'm new to rep-server. We've just set-up a warm standby
Can anyone pls. tell me the step by step procedure on
shutting down the warm-standby system? (what commands to
execute to which server (active/standby/repserver).
I would like also to know the step by step procedure in
starting up the warm standby.
<saz> wrote in message news:firstname.lastname@example.org...
> I'm new to rep-server. We've just set-up a warm standby
> using rep-server.
> Can anyone pls. tell me the step by step procedure on
> shut...How to turn off replication for one table in warm standby
Without using "set replication off", is there a way to turn
off replication for one table in warm standby environment?
> Without using "set replication off", is there a way to turn
> off replication for one table in warm standby environment?
Not really if you use sp_reptostandby - however, if using RS 12.6, you
can switch to the MSA feature instead of WS - since it uses database
level repdef's (along with table level) and the syntax for database
level repdef's includes the ability to exclude tables or transactions by
nam...Not to replicate one table in Warm Standby setup
We have a Warm Standby setup and everything replicates fine, but at the
monthend one of the table has bottleneck replicating the data, as it is the
P&L table, lots of deletion and insertion tables place and deletion takes a
long time. Is there anyway to disable the replication for on this table
and retain w/standby for the rest?
<Subbu> wrote in message
> We have a Warm Standby setup and everything replicates fine, but at the
> monthend one of the table has bottleneck replic...To drop a table which is not in Warm standby server but in primary ase
Hi all Sybase Rep Guru's,
Some time back i needed to backup a table so i did it by
select * into tbl_name from tbl_name
on my primary server which was running on sun solaris 2.7 ase 18.104.22.168
with rep server 11.5.1
later to my notice i saw this particular table was not avialable in my
Now i want to drop this table as i no long need it but i have not done
thinking that when i try to drop
this table it tries to drop it in the warm standby also and since it
does not find it there it might break the replication on our site which
replicates to a reporting server...Can Warm Standby become Primary for another Rep Server
We currently have a Rep Server environment with a primary server A and
warm standby server B. The Rep Server for this environment is RS1. The
equipment lies in LA and we would like to migrate it to Bellevue, WA.
The proposal is to build a new warm standby server C and to have the RS1
Rep Server point the warm standby from server B [LA] to server C
[Bellevue]. After that I have been asked if it is possible to have warm
standby server C for Rep Server RS1 to become a primary for a new Rep
Server environment RS2 and a new warm standby in Bellevue called sever D