Brad Chen's SQL Server Blog

MS, SQL Server Support, Guidelines, Tips, Troubleshooting

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 ...
  • Blog Post: 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會出現驚嘆號...
  • Blog Post: 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...
Page 1 of 1 (6 items)