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

Question

Post reply

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

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
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.
October 1, 2022 at 11:04 am

This was removed by the editor as SPAM

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

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

Site Owners SSC Guru Points: 80325 More actions · Answer 1

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

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

Jeff Moden SSC Guru Points: 1004401 More actions · Answer 2

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)

Jeff Moden SSC Guru Points: 1004401 More actions · Answer 3

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)