静默你复制拓扑

一个有趣的问题出现在我最近的SQL Server 2008类。当我们覆盖复制,一个学生问当你停止复制停止第一,出版商还是用户?我必须承认,答案没有立即涌上心头。他的想法是先关闭出版商如果没有复制的用户有未更新?相反,如果你首先关闭用户,他们可能没有更新的出版商。我从Sybase,记得有一个QUIESCE数据库语句,优雅地关闭数据库允许未更新完成不让新的事务开始。但这样的声明并不存在于Microsoft SQL Server。所以我用谷歌搜索了静默,发现维基词典定义——成为“安静”。但是维基百科上有一篇好文章这个词,因为它涉及到数据库技术。什么一个惊喜。 It turns out DB2 supports a Quiesce statement. So does Oracle. Even Sharepoint does. But not Microsoft SQL Server. Then I found a great article on MSDN entitled "How to: Quiesce a Replication Topology". That was it. Even though there is no Quiesce statement this document describes the steps to synchronize your Publisher with its Subscribers. The steps are different depending on the type of Replication, but the document spells it out for you. So which do you shut down first, the Publisher or the Subscribers? The answer is: it really doesn't matter as long as you have successfully quiesced your replication topology first. Now here's the real challenge: go use the word Quiesce in a normal conversation today. "I wish my kids would quiesce..." cheers Brian "How to: Quiesce a Replication Topology": http://msdn.microsoft.com/en-us/library/ms147385(SQL.90).aspx