shyamsundar20

 Profile Answers by shyamsundar20 

• Sep 22nd, 2008

 

I believe we wont be able to clear log segment when secondary truncation point is on.

However, we can try running dump tran with truncate_only and checkpoint.

could someone with more details shed for some details.

dhampack

 Profile Answers by dhampack 

• Nov 23rd, 2008

 

There are only two options to clear the log
1) Kill the tran which is filling up the log
2) Extend the transaction log to complete the transaction.

don't use 'dump with truncate_only' if you have tran dump job setup.
I would also stop and restart rep agent, I have seen some cases where rep agent gets hung and don't process transactions.

luisgranados

 Profile Answers by luisgranados 

• May 20th, 2011

 

I suppose you want to do that because you refresh the database to a development/QA environment and you no longer need the replication to be working.

So you just need to disable the secondary truncation point using the following command:

dbcc settrunc(ltm,'ignore')


---
Luis Ignacio Granados
Sybase DBA