Post reply

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

  • September 22, 2022 at 1:53 pm

    #4090798

    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.

  • September 23, 2022 at 2:10 pm

    #4091234

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

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

  • October 1, 2022 at 11:04 am

    This was removed by the editor as SPAM

  • October 1, 2022 at 4:37 pm

    #4094385

    KWood9457 wrote:

    This works really well for us, thank you!

    Smells like a preamble to SPAM.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • October 1, 2022 at 4:38 pm

    #4094386

    SQL_Hunt wrote:

    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?

    How are you doing the migration?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

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