Merge Replication adding Rowguid manually
-
Tuesday, April 03, 2012 1:07 PM
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
- Edited by KEROBIN Tuesday, April 03, 2012 1:07 PM
All Replies
-
Tuesday, April 03, 2012 1:47 PMModerator
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
-
Wednesday, April 04, 2012 5:29 AMThanks 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
- Edited by KEROBIN Wednesday, April 04, 2012 5:29 AM
-
Thursday, April 05, 2012 6:34 AMModerator
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).aspxRegards, Amber zhang
-
Monday, April 09, 2012 7:25 AMThe article is for SQL Server 2000.. Is it the same for SQL server 2008 R2 as well..??
- Kerobin
- Edited by KEROBIN Monday, April 09, 2012 7:25 AM
-
Monday, April 09, 2012 8:48 AMModerator 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).aspxRegards, Amber zhang
- Marked As Answer by amber zhangModerator Wednesday, April 11, 2012 3:04 AM
-
Monday, April 09, 2012 1:27 PMModerator 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
- Marked As Answer by amber zhangModerator Wednesday, April 11, 2012 3:04 AM
.png)
