Restoring a publication database to test instance

• jdbrown239

  SSCarpal Tunnel

  Points: 4393

  More actions

  November 15, 2016 at 6:44 am

  #315734

  Hello

  I have a publication database with merge replication. I used a backup of this database to refresh a test database (not replicated) and notice the 'ROWGUID' after the restore was no longer there. Is this normal behavior and does anyone have a link to an article or documentation?

  Thanks

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  November 15, 2016 at 7:25 am

  #1912499

  Did you specify WITH KEEP_REPLICATION when you did the restore?

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b2ee9679-50a6-45b6-a632-6fec933df467/rowguid-column-not-restoring-for-merge-replicated-db?forum=sqlreplication

• jdbrown239

  SSCarpal Tunnel

  Points: 4393

  More actions

  November 15, 2016 at 9:52 am

  #1912598

  No I didn't specify. Thanks for the link that answered my question.