March 26, 2024 at 12:20 pm
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
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy