AlwaysOn Availability Groups learning resources

Overview of AlwaysOn Availability Groups (SQL Server) http://msdn.microsoft.com/en-us/library/ff877884.aspx Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server) http://msdn.microsoft.com/en-us/library/ff878487.aspx SQL AlwaysOn 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/ AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution…


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…


Setup SQL Server 2012 AlwaysOn Availability Groups using Certificate

Setup SQL 2012 AlwaysOn Availability Groups using Certificate 1.如果SQL Server的啟動帳戶使用本機帳戶或虛擬帳戶Virtual Account(本機受管理的服務帳戶Managed Local Accounts),若要在這種環境下設定AlwaysOn,則必須使用憑證Certificate來設定。 安裝SQL Server 2012時SQL Server服務的預設啟動帳戶就是Virtual Account,也就是NT Service\MSSQLSERVER 以下範例:2個Instance都是使用NT Service\MSSQLSERVER 2.使用憑證Certificate建立端點Endpoint與相關登入帳戶與權限設定 (1)Create encryption key, certificate and end-points on Principal Instance USE [master] GO SELECT * FROM sys.symmetric_keys; GO — Create Database Master Key CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘P@ssw0rd’; GO CREATE CERTIFICATE AG_HOST_SQL2012A1_PRIN_Cert…


Setup SQL Server 2012 AlwaysOn Availability Groups using Join Only

Setup SQL 2012 AlwaysOn Availability Groups using Join Only 1.事先將主要Instance上的MyDB資料庫做備份(a Full Backup and a Log Backup)並指定NO RECOVERY 還原到第二個Instance。 — 第1個也就是主要的Instance SQL2012A1 BACKUP DATABASE [MyDB] TO DISK = N’C:\Temp\MyDB.bak’ GO BACKUP LOG [MyDB] TO DISK = N’C:\Temp\MyDB.trn’ GO — 第2個Instance SQL2012A2 RESTORE DATABASE [MyDB] FROM DISK = N’C:\Temp\MyDB.bak’ WITH NORECOVERY GO RESTORE LOG [MyDB] FROM DISK…


Setup SQL Server 2012 AlwaysOn Availability Groups using Skip initial data synchronization

Setup SQL 2012 AlwaysOn Availability Groups using Skip initial data synchronization 1.在選取初始資料同步處理時,選擇[略過初始資料同步處理](Skip initial data synchronization) 2.驗證時會略過很多項目 3.完成時也會略過很多項目 4.此時AG新增成功,因為第二的Instance還沒有MyDB資料庫存在,所以在第二個Instance的可用性資料庫會出現驚嘆號 5.啟動[顯示儀表板],第二個Instance的MyDB會出現驚嘆號,同步處理狀態為”未進行同步處理” 6.接著可以進行新增可用性群組接聽程式。請參考這篇 Quick Setup a SQL Server 2012 AlwaysOn Availability Groups  的步驟7.新增可用性群組接聽程式 7.將主要Instance上的MyDB資料庫做備份(a Full Backup and a Log Backup)並指定NO RECOVERY 還原到第二個Instance。 — 第1個也就是主要的Instance SQL2012A1 BACKUP DATABASE [MyDB] TO DISK = N’C:\Temp\MyDB.bak’ GO BACKUP LOG [MyDB] TO DISK =…


Quick Setup a SQL Server 2012 AlwaysOn Availability Groups

Quick Setup a SQL 2012 AlwaysOn Availability Groups 以下範例所有Instance的SQL Server啟動帳戶都同一個網域帳戶(domain user account),如果您的SQL啟動帳戶是本機帳戶或虛擬帳戶Virtual Account(本機受管理的服務帳戶Managed Local Accounts),請參考這篇 Setup SQL Server 2012 AlwaysOn Availability Groups using Certificate 使用憑證來設定AlwaysOn AD Domain User Account Domain Name:lab21.local NETBIOS Domain Name:LAB21 Domain User Account: SQLServer 第一個節點的SQL Server Instance的SQL Server啟動帳戶已設定為LAB21\SQLServer 第二個節點的SQL Server Instance的SQL Server啟動帳戶也設定為LAB21\SQLServer [開始設定SQL Server 2012 AlwaysOn Availability Groups] 1.Create a Windows Cluster…