Skip to Content
Former Member
Jun 06, 2014 at 04:39 PM

Is my database replicated?


Sybase version: Adaptive Server Enterprise/15.0.3/EBF 17690 ESD#1.1 RELSE/P/Solaris AMD64/OS 5.10/ase1503/2681/64-bit/FBO/Thu Aug 20 15:37:40 2009

Good afternoon,

We received a database from a customer to 'migrate'.

The database has 10Gb for the log segment.

One of my colleague face a LOG SUSPEND even though he added 20Gb on log segment.

My first assumption is that the database is 'replicated'.

First of all, I know nothing about replication so my assumptions are based on my own understanding.

The first thing I did is execute the command "sp_reptostandby" and it returns the following.

The replication status for database 'TPK0001695_12787890' is 'ALL'.

The replication mode for database 'TPK0001695_12787890' is 'off'.

so for me the database is replicated but now looking at the replication mode, it states 'off' so what's actually replicated?

then I executed "sp_setrepdbmode" and it returns

The replication mode for database 'TPK0001695_12787890' is 'off'.

The replication threshold for table 'TPK0001695_12787890' is '50'.

From what I uderstand any query modifying more than 50 rows is replicated but as the mode is off, what's replicated?

Finally I executed "dbcc gettrunc' and it returns

----------- ------ ------ ----------- ------ ------------------------------ -----------

8113058 0 142 0 5 TPK0001695_12787890 0

First 'strange' thing is there's no column name. so from the ouput I don't know if the LTM is set but I guess value 8113058 is a page number meaning LTM is set.

Hence, based on these outputs can I conclude my database is replicated?

If YES, how to disable it? for me I'll execute "exec sp_reptostandby <DB NAME>,'none'" and "dbcc settrunc (ltm,ignore)". is this the right way.

last question whenever replication is set, does it mean there's a LTM in the transaction log?

Thanks all and have a nice week-end.