Post reply

Replication from SQL 2008R2 to SQL 2012

  • March 12, 2013 at 12:41 am

    #275150

    Gurus,

    I have weird replication issue. Can't figure out what the issue is here. Please help me with ideas/known bugs(if any):w00t:

    Publisher: SRVA - SQL 2008R2

    Distributor: SRVB - SQL 2008R2

    Subscribers: SRV1 - SQL 2008R2

    SRV2 - SQL 2008R2

    SRV3 - SQL 2008R2

    SRV4 - SQL 2012

    Number of Publications: 3

    originally, replication was set-up from backup. later on, we had to add couple of articles to Publication-3. we followed an article which said to switch off “immediate_sync” and “allow_anonymous” to false and re-snap. This way, we will take snap of only the two articles we have to add.

    Now, the issue is, we had to add two more articles today, when we followed same procedure, snapshot agent has created drop and re-create scripts for the two articles. However, create table scripts were not applied to the SRV4. Rest of all the procs for repl insert, update, delete were created on this instance. Just the tables and thier pks weren't created.

    Fixed the issue by manually creating the table and Pk. Stopped and re-started Distributed agent and everything started to work fine.:pinch:

    Checked the permissions for snapshot, distributed agents. Everything is normal with regards to permissions. Can't find a root cause of the issue.

    Please help!!:crying:

    Thanks

    Jagan K

    Thanks
    Jagan K

  • March 12, 2013 at 6:11 am

    #1595936

    can someone please shed some light. i want to know the root cause of this issue.

    Thanks

    Thanks
    Jagan K

  • March 13, 2013 at 5:18 am

    #1596432

    One aspect is that you need to do all changes that affect a SQL 2012 box from SQL 2012 Management Studio. If you use SQL 2008 R2 SSMS, then most things will work but some do not.

    We had similar problems as we started to deploy SQL 2012, and mostly they went away when we standardised on using SQL 2012 SSMS.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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