Clearing the pending transaction from the Replication logs before taking the bkp

  • Hello,

    Before migrating the databases to the new servers, if I need to make sure that all the pending transactions from the Replication queue logs are cleared, so that in the new environment while the dbs are migrated nothing is lost.

    Is running ".

    EXECUTE sys.sp_flush_log" enough? Or do you suggest we need to perform any other steps?

     

    Thanks.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • This works really well for us, thank you!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply