none
Rowguid column not restoring for merge replicated db

    Question

  • I am trying to take backup of a merge replicated database and restore it in another server but rowguid column is not restored. Why does rowguid column not restored? How to solve this problem?
    Wednesday, November 21, 2012 6:15 AM

Answers

  • Hi Winman Software,

    You have 2 options:

    1)  You can use the WITH KEEP_REPLICATION restore option when restoring the database.  This will preserve the rowguid column when doing the restore.

    2) Alternatively, prior to taking the backup, execute the following for each article:

    UPDATE dbo.sysmergearticles SET preserve_rowguidcol = 1 WHERE type = 10 and name = 'MyTable'

    Then backup and restore as usual and the rowguid column will be preserved.


    Brandon Williams (blog | linkedin)

    Wednesday, November 21, 2012 7:01 AM
    Moderator

All replies

  • You mean to say, you dont see the the ROWGUID column on table on restored database?


    Kindly mark the reply as answer if they help

    Wednesday, November 21, 2012 6:35 AM
  • Yes. ROWGUID column is not there in tables of restored database.
    Wednesday, November 21, 2012 6:48 AM
  • Hi Winman Software,

    You have 2 options:

    1)  You can use the WITH KEEP_REPLICATION restore option when restoring the database.  This will preserve the rowguid column when doing the restore.

    2) Alternatively, prior to taking the backup, execute the following for each article:

    UPDATE dbo.sysmergearticles SET preserve_rowguidcol = 1 WHERE type = 10 and name = 'MyTable'

    Then backup and restore as usual and the rowguid column will be preserved.


    Brandon Williams (blog | linkedin)

    Wednesday, November 21, 2012 7:01 AM
    Moderator