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?

Answer 1

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

Answer 2

Yes. ROWGUID column is not there in tables of restored database.

Answer 3

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)