log truncate and secondary truncation point steps

[jmtorres]

Hello guys,

I'm looking for the correct steps in the case that transaction log fills or cannot be dumped due to secondary truncation point.So I would like to check if these are the correct steps in a Warm Standby using Rep Server 15.7.1 % ASE 15.7

At primary ASE:

use db

go

dbcc settrunc('ltm','valid')

go

sp_configure "primary_db", single user, true

go

suspend connection to ds.db

go

sp_stop_rep_agent primary_db / ** or sp_config_rep_agent 'disable'. ?? **/

go

dbcc settrunc('ltm',ignore')

go

dump tran primary_db with no_log / truncate_only

go

use <rssd>

go

rs_zeroltm ds,db

go

sp_start_rep_agent primary_db

go

resume connection to ds.db

go

Thank you

Regards

Jose

[jmtorres]

Mark,

Thank you very much.

Do you  know or where can I find information regarding from which ASE error severity level and up Replication server  maps this  to "STOP_REPLICATION"?

Regards

Jose