Replication Reinitialization from backup

• Saran

  Right there with Babe

  Points: 760

  More actions

  March 27, 2024 at 12:21 pm

  #4403121

  I have Reinitialization transactional replication of 950 GB database from backup. It is working fine.

  I left allow_anonymous & immediate_sync 1 i.e true. I plan to keep it as true.

  Is that fine or do I need to change to false. I have tried to put false, it is making lot of blocking in the published database.

  Please advise.

• ratbak

  Ten Centuries

  Points: 1358

  More actions

  March 27, 2024 at 1:09 pm

  #4403149

  Duplicate of https://www.sqlservercentral.com/forums/topic/replication-reinitialization-from-backup

• Saran

  Right there with Babe

  Points: 760

  More actions

  April 2, 2024 at 11:32 am

  #4406389

  Yes, it is duplicate post. I wrongly posted under replication section but that is for SQL 2000.