問(wèn)題描述
3 種復(fù)制有什么區(qū)別?復(fù)制適用于數(shù)據(jù)歸檔嗎?復(fù)制步驟是什么?
What is difference between 3 type of replication? Is replication suitable for data archiving? What is the replication steps?
推薦答案
以下是 SQL Server 中的三種復(fù)制類型.
Following are the three types of replication in SQL server.
- 事務(wù)復(fù)制
- 合并復(fù)制
- 快照復(fù)制
有關(guān)更多信息,請(qǐng)參見(jiàn) http://technet.microsoft.com/en-我們/圖書(shū)館/ms152531.aspx
For more See http://technet.microsoft.com/en-us/library/ms152531.aspx
復(fù)制也可用于存檔目的,但需要一些額外的機(jī)制.大部分時(shí)間我看到,它用于數(shù)據(jù)倉(cāng)庫(kù)場(chǎng)景,以減少OLTP系統(tǒng)的負(fù)載.
Replication can be used for archiving purposes as well but with some additional mechanisms. Most of the time I have seen, it is used in data warehousing scenarios to reduce load on the OLTP system.
這篇關(guān)于SQL Server 復(fù)制的文章就介紹到這了,希望我們推薦的答案對(duì)大家有所幫助,也希望大家多多支持html5模板網(wǎng)!