Monday 18 April 2011

ASE : What if logsegment is full because of replication

It’s very frustrating when this happens. you can not dump transaction because the sendary truncation point from replication. the dump tran command works but logsegment is still full. Then you can not disable the replication, because the log is almost full. Below is the steps to handle this situation

1) sp_stop_rep_agent dbname
2) dbcc settrunc(ltm,ignore)
3) dump tran dbname -or-
dump tran dbname with truncate_only
4) (in the rssd): rs_zeroltm dsname, dbanme
afterward, we have to resync the databases.

No comments:

Post a Comment