Merge Replication adding Rowguid manually

Question

Is it a good practice to have a rowguid with rowguidcol property in a table permanently for merge replication..??

How is it been handled during backup and restore of publisher, distributor or subscriber..??

---

 - Kerobin

Answer 1

Yes it is. However you can use this column for your own primary key if you want.

Merge replication will handle uniqueness.

This key/column is not a problem for backup/restores the way identity columns can be.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

Thanks for your reply Hilary. I'm also wondering what is the use of keep_replication while doing DB restore operation and how it works..??

---

- Kerobin

Answer 3

Hi Kerobin,

The KEEP_REPLICATION option is used to setting up replication to work with log shipping. It prevents replication settings from being removed when a database or log backup is restored on a standby server. Specifying this option when restoring a backup with the NORECOVERY option is not permitted.

For more information, please refer to here http://msdn.microsoft.com/en-us/library/aa238405(v=sql.80).aspx

 

---

Regards, Amber zhang

Answer 4

The article is for SQL Server 2000.. Is it the same for SQL server 2008 R2 as well..??

---

- Kerobin

Answer 5

Hi Kerobin,

Thank you for your update. For SQL Server 2008 R2 you can refer to this article .

Meanwhile you can refer to Preserve the replication settings section this article Restore Database (Options Page) http://msdn.microsoft.com/en-us/library/ms188223(v=sql.105).aspx

---

Regards, Amber zhang

Answer 6

The keep_replication switch is used to preserve replication metadata when restoring a database. It can be used for log shipping, but it can also be used for debugging, or just querying replication metadata from another source other than the publication database.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941