Post reply

Replication Reinitialization from backup

  • March 26, 2024 at 12:20 pm

    #4402422

    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

    SQL 2014 version

  • March 26, 2024 at 5:58 pm

    #4402612

    Are you really using SQL 2000 or SQL 7?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • March 27, 2024 at 12:18 pm

    #4403120

    No , It is SQL 2014.

    I do not see replication in 2014 , I have posted here.

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

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