Windows2012配置SQLServer2014AlwaysOn的图解

<code class="hljs scss">基于Vmware workstation 12，4台虚拟机，其中一台域控，3个SQL节点，使用NAT模式，关闭DHCP 
此处为简化演示，先安装2个节点的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';

<喎"https://www.jb51.net/kf/ware/vc/" target="_blank" class="keylink">vcD4NCjxwPjxjb2RlIGNsYXNzPQ=="hljs scss">2)指定可用性组名称