<code class="hljs scss">基于Vmware workstation 12，4臺虛擬機，其中一臺域控，3個SQL節(jié)點，使用NAT模式，關閉DHCP 
此處為簡化演示，先安裝2個節(jié)點的AlwaysOn，即SQLnode1，SQLnode2 
機器名稱 IP GateWay DNS
SQLDC 192.168.171.20 192.168.171.2 127.0.0.1
SQLnode1(主) 192.168.171.21 192.168.171.2 192.168.171.20
SQLnode2(輔) 192.168.171.22 192.168.171.2 192.168.171.20
SQLnode3(輔) 192.168.171.23 192.168.171.2 192.168.171.20
AlwaysOnWSFC 192.168.171.18 
</code>

<code class="hljs scss"> [安裝Windows 2012域控(For SQLServer 2014 AlwaysOn)](http://blog.csdn.net/leshami/article/details/51180359)
[Windows 2012配置故障轉移(For SQLServer 2014 AlwaysOn)](http://blog.csdn.net/leshami/article/details/51218021)
[安裝SQLserver 2014(For AlwaysOn)](http://blog.csdn.net/leshami/article/details/51224954)
</code>

<code class="hljs scss"><code class="hljs sql">此處演示我們基于SQLnode1,作為主副本 
CREATE DATABASE AlwaysonDB1; 
GO 
CREATE DATABASE AlwaysonDB2; 
GO 
USE AlwaysonDB1; 
GO 
CREATE TABLE t1 (id INT ,dbname VARCHAR(20)); 
INSERT INTO t1 VALUES ( 1, 'AlwaysonDB1' ); 
USE AlwaysonDB2; 
CREATE TABLE t2 (id INT ,dbname VARCHAR(20)); 
INSERT INTO t2 VALUES ( 1, 'AlwaysonDB2' ); </code></code>

此步驟可以省略，可以在初始化的時候有SQLserver自行備份及還原
backup database AlwaysonDB1 to disk='C:\AlwaysonBAK\AlwaysonDB1.BAK';
backup database AlwaysonDB2 to disk='C:\AlwaysonBAK\AlwaysonDB2.BAK';

<喎�"http://m.fzitv.net/kf/ware/vc/" target="_blank" class="keylink">vcD4NCjxwPjxjb2RlIGNsYXNzPQ=="hljs scss">2)指定可用性組名稱