- 论坛徽章:
- 0
|
rs_helprep
Replication Definition Name PRS Primary DS.DB Primary Table Replicate Table Type
--------------------------- --- ------------- ------------- --------------- ----
rs_classes JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_classes Tbl
rs_columns JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_columns Tbl
rs_databases JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_databases Tbl
rs_dbreps JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_dbreps Tbl
rs_dbsubsets JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_dbsubsets Tbl
rs_erroractions JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_erroractions Tbl
rs_funcstrings JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_funcstrings Tbl
rs_functions JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_functions Tbl
rs_objects JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_objects Tbl
rs_routes JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_routes Tbl
rs_systext JIFEIRS JIFEI_RSSD.JIFEIRS_RSSD rs_systext Tbl
select objname , phys_tablename from rs_objects
没有表名啊
objname phys_tablename
------- --------------
rs_classes rs_classes
rs_columns rs_columns
rs_databases rs_databases
rs_dbreps rs_dbreps
rs_dbsubsets rs_dbsubsets
rs_erroractions rs_erroractions
rs_funcstrings rs_funcstrings
rs_functions rs_functions
rs_objects rs_objects
rs_routes rs_routes
rs_systext rs_systext
还有个问题,我不是想增加复制定义,我是想在复制定义里增加表,就像文档里
create database replication definition ... with ... replicate table in(tab1,tab2...)
不知道在alter时怎么用,我看例子里有过滤的,但是没有增加的
alter database replication definition ...with ... not replicate table in(tab1)
因为是正式库,我没有其他环境,时间又比较近,所以我不敢随便乱测试,不知道是不是
alter database replication definition ...with ... replicate table in(tab1) 这样就添加了一个新表吗?还是把原来定义的表给覆盖了啊,我不敢随便测
还有我在执行以下命令是报了这个错不知道是怎么回事
1> sp_setreptable xwrep_test, true
2> go
Msg 9137, Level 16, State 2:
Server 'APCHUANBO3', Procedure 'sp_setreptable', Line 513:
LTM trunc. point not yet established with DBCC SETTRUNC(). Until the LTM trunc. point is established, changes to the object 'xwrep_test' may not be replicated.
The replication status for 'xwrep_test' is set to true, owner_off.
1> create subscription xwrep_test_sub for rep_test with replicate at JIFEI.bohai
2> go
Msg 15249, Level 12, State 0:
Server 'JIFEIRS':
Can not use active or standby connection names for subscriptions
|
|