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…

0

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…

0

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…

0

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…

0

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 =…

0

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…

0