Brad Chen's Developer Blog Azure Database Data science Machine Learning Cloud
2014年6月18日 星期三
Always On Availability Groups learning resources (Always On Availability Groups學習資源與文件)
Always On Availability Groups學習資源與文件
from my MSDN blog - June 18, 2014
Overview of Always On Availability Groups (SQL Server)
http://msdn.microsoft.com/en-us/library/ff877884.aspx
Prerequisites, Restrictions, and Recommendations for Always On Availability Groups (SQL Server)
http://msdn.microsoft.com/en-us/library/ff878487.aspx
SQL Always On Team Blog
http://blogs.msdn.com/b/sqlalwayson/
SQL Server Customer Advisory Team
http://blogs.msdn.com/b/sqlcat/
MSDN Blogs > Brad Chen's SQL Server Blog > All Tags > alwayson
http://blogs.msdn.com/b/bradchen/archive/tags/alwayson/
Always On Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using Failover Cluster Instances and Availability Groups
http://msdn.microsoft.com/en-us/library/jj215886.aspx
[Building a High Availability and Disaster Recovery Solution using AlwaysOn Availability Groups.docx]
SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance
http://msdn.microsoft.com/en-us/library/hh750283.aspx
[SQLServer2012_MultisiteFailoverCluster.docx]
SQL Server High Availability and Disaster Recovery for SAP Deployment at QR: A Technical Case Study
http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQLServer_HADR_QR.docx
How to create a failover cluster 如何新增一個容錯移轉叢集
How to create a failover cluster
如何新增一個容錯移轉叢集
1.In the Failover Cluster Manager snap-in, confirm that Failover Cluster Manager is selected and then, under Management, click Create a Cluster.
2.Follow the instructions in the wizard to specify:
- The servers to include in the cluster.
- The name of the cluster.
- Any IP address information that is not automatically supplied by your DHCP settings.
3.After the wizard runs and the Summary page appears, if you want to view a report of the tasks that the wizard performed, click View Report.
To view the report after you close the wizard, see the following folder, where SystemRoot is the location of the operating system (for example, C:\Windows):
SystemRoot\Cluster\Reports\
[Reference]
Create a New Failover Cluster
https://technet.microsoft.com/en-us/library/cc755129.aspx
SQL Server Planning, Pricing and License
Server-CALs授權模式 1.需購買的量應該是所有終端用戶的電腦 例如:一台Data warehouse主機 與 一台Web報表主機,但公司有50人或電腦會連進Web報表主機開啟報表,則應該每一台用戶端電腦都需要有CALs授權,Data warehouse主機購買Ser...
-
1.安裝了Oracle Client,就可以用Oracle Net Manager工具來設定TNS連線設定(Tnsnames.ora) Oracle Client 18.3 Installation 安裝Oracle Client 18.3 2.啟動Oracle Ne...
-
SQL Server Integration Service可以透過內建的OLE DB Source連線到Oracle匯出資料,但無法寫入資料到Oracle,Attunity公司針對這個功能提供了SSIS的連結Source,並且聽說資料傳送效率非常好,本人沒有測試過效能,有興趣的...
-
1.下載 Oracle Database 18c (18.3) https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-windows-180000-5066774.ht...