Wednesday, November 21, 2012 6:15 AMI 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:35 AM
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:48 AMYes. ROWGUID column is not there in tables of restored database.
Wednesday, November 21, 2012 7:01 AMModerator
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.
- Edited by Brandon WilliamsMicrosoft Community Contributor, Moderator Wednesday, November 21, 2012 7:17 AM
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, November 29, 2012 2:11 PM