资源描述：
《sqlserver复制的概念》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、SQLSERVER复制的概念TheconceptofreplicationReplicationisthetechniqueofcopyingasetofdata,fromonedatasourcetomultipledatasources,whichisanefficientwaytopublishadatatomultipiestoragesites.Usingreplicationtechnology,userscanpublishapieceofdatatomultipleservers,sothatdi
2、fferentserveruserscansharethedatawithinthescopeofpermissions・Replicationtechniquesensurethatdataatdifferentlocationsisautomaticallyupdatedsynchronouslysoastoensuredataconsistency・ThebasicelementsofSQLreplicationincludePublishingservers,subscribers,distributio
3、nservers,publications,articlesTheworkingprincipleofSQLreplicationSQLSERVERmainlyusespublicationsandsubscriptionstoprocessreplication.Theserverwherethesourcedataresidesisthepublishingserver,whichisresponsibleforpublishingdata.Allchangestotheserverpublishingdat
4、apublishedbythecopytothedistributor,thedistributorincludesadistributiondatabase,canallchangetoreceivedata,andsavethesechanges,thenthesechangesdistributedtosubscribersSQLSERVERreplicationtechnologytypeSQLSERVERoffersthreereplicationtechnologies,namely:1snapsho
5、treplication(we'11useitlater)2,transactionreplication3,mergereplicationAslongastheaboveconceptsareclear,thenthereisacertainunderstandingofreplication・Next,wewillstepbysteptoimplementthereplicationprocess・First,configurethepublishingserver(1)selectthespecified
6、[server]node(2)select[publish,subscribe,anddistribute]commandsfromthecopysubmenuofthetoolsdrop-downmenu(3)thesystempopsupadialogbox[nextstep]andthenlooksatthepromptuntilit'sdone・(4)whenapublicationserverissetup,thesystemaddsacopymonitortothetreestructureofthe
7、server.Adistributiondatabase(distribution)isalsogeneratedSecondcreatepublications(1)checkthespecifiedserver(2)select[createandmanagepublishing]commandsfromthecopysubmenuofthetoolsmenu.Atthispoint,thesystemwillpopupadialogbox(1)selectthedatabasewhereyouwanttoc
8、reatethepublication,andthenclickCreatePublishing(2)inthecreatepromptWizarddialogbox,click[next],thesystemwillpopupadialogbox・Thecontentonthedialogboxisthethreetypeofreplication・Wewillnowc
