¼ò½é
SQL Server2012ÖÐÐÂÔöµÄAlwaysOnÊÇÒ»¸öÐÂÔö¸ß¿ÉÓÃÐÔ½â¾ö·½°¸¡£ÔÚAlwaysOn֮ǰ£¬SQL ServerÒѾÓеĸ߿ÉÓÃÐÔºÍÊý¾Ý»Ö¸´·½°¸,±ÈÈç
Êý¾Ý¿â¾µÏñ£¬ÈÕÖ¾´«Ëͺ͹ÊÕÏ×ªÒÆ¼¯Èº.¶¼ÓÐÆä×ÔÉíµÄ¾ÖÏÞÐÔ¡£¶øAlwaysOn×÷Ϊ΢ÈíÐÂÍ˳öµÄ½â¾ö·½°¸£¬ÌáÈ¡ÁË
Êý¾Ý¿â¾µÏñºÍ¹ÊÕÏ×ªÒÆ¼¯ÈºµÄÓŵ㡣±¾ÎÄÖ¼ÔÚͨ¹ýʵÏÖÒ»¸öAlwaysOnµÄʵÀýÀ´Õ¹ÏÖAlwaysOn¡£
ÅäÖÃAlwaysOn
ËäÈ»AlwaysOnÏà±È½Ï֮ǰ°æ±¾µÄ¹ÊÕÏ×ªÒÆ¼¯Èº¶øÑÔ£¬²½ÖèÒѾ¼ò»¯ÁËÐí¶à¡£µ«ÅäÖÃAlwaysOnÒÀÈ»ÊÇÒ»¼þ±È½ÏÂé·³µÄÊ£¬²»½öÐèÒªÄã¶ÔSQL Server±È½ÏÊìϤ£¬»¹ÐèÒª¶ÔWindows ServerÓÐËùÁ˽⡣±¾ÎÄÅäÖÃAlwaysOn·ÖΪÁ½¸ö°å¿é£¬·Ö±ðΪ:ÅäÖÃWindowsºÍÅäÖÃSQL Server¡£
ÔÚ¿ªÊ¼ËµµÀÅäÖÃWindows֮ǰ£¬Ê×Ïȼòµ¥½éÉÜһϲâÊÔ»·¾³¡£
ÎÒ´îÁËÈý̨Windows Server 2008µÄ
ÐéÄâ»ú£¨SQL SERVER 2012±È½ÏÂé·³£¬±ØÐë2008 sp2ÒÔÉϰ汾
windows server²ÅÄܰ²×°£©,Èçͼ1Ëùʾ¡£ÆäÖн«»î¶¯Ä¿Â¼ºÍDNS·þÎñÆ÷°²ÔÚÁËWindows Server2008 Server 1.ûÓÐÆôÓÃDHCP·þÎñÆ÷£¬Èý̨·þÎñÆ÷µÄIP·Ö±ðΪ192.168.100.1/24,192.168.100.2/24,192.168.100.3/24¡£
ͼ1.Èý̨װÓÐWindows Server2008µÄ²âÊÔÐéÄâ»ú
Èý̨·þÎñÆ÷¶¼¼ÓÈëÁËÓÉWindows Server 2008 Server1×÷ΪAD½¨Á¢ÓòSQL2012.TEST¡£Èý̨ÐéÄâ»úµÄÃû³Æ·Ö±ðΪSQLServerTest1,SQLServerTest2,SQLServerTest3¡£
ÅäÖÃWindows Server
Ê×ÏÈÔÚ·Ö±ðÔÚÈý̨²âÊÔ·þÎñÆ÷Éϰ²×°¹ÊÕÏ×ªÒÆ¼¯ÈºµÄ¹¦ÄÜ£¬Èçͼ2Ëùʾ¡£

ͼ2.ÔÚ²âÊÔ·þÎñÆ÷Éϰ²×°¹ÊÕÏ×ªÒÆ¼¯ÈºµÄ¹¦ÄÜ
ÔÚ°²×°ºÃ¹ÊÕÏ×ªÒÆ¼¯ÈºµÄ¹¦ÄÜÖ®ºó£¬ÔÚServer1ÉϽøÐжԼ¯ÈºµÄÅäÖÃ.Èçͼ3Ëùʾ¡£

ͼ3.ÔÚ¹ÊÕÏ×ªÒÆ¼¯Èº¹ÜÀíÖд´½¨¼¯Èº
È»ºóÔÚ½ÓÏÂÀ´µÄ²½ÖèÖУ¬½«Èý̨·þÎñÆ÷¼ÓÈ뼯Ⱥ£¬Èçͼ4Ëùʾ¡£

ͼ4.½«Èý̨²âÊÔ·þÎñÆ÷¼ÓÈ뼯Ⱥ
µã»÷ÏÂÒ»²½£¬½øÐвâÊÔ,Èçͼ5Ëùʾ¡£

ͼ5.¶Ô¼¯Èº½øÐÐÑéÖ¤²âÊÔ
µã»÷ÏÂÒ»²½£¬Ìí¼Ó¼¯ÈºÃû³Æ,Èçͼ6Ëùʾ¡£

ͼ6.Ìí¼Ó¼¯ÈºIPºÍ¼¯ÈºÃû³Æ
È»ºóµã»÷ÏÂÒ»²½È·ÈϺó£¬×îºóÍê³É¼¯ÈºµÄ´´½¨£¬Èçͼ7Ëùʾ¡£

ͼ7.Íê³É¼¯ÈºµÄ´´½¨
ÅäÖÃSQL Server
ÔÚÅäÖÃÍêWindows ServerÖ®ºó£¬¾Í¸ÃÅäÖÃSQL SERVERÁË¡£·Ö±ðÔÚÈý̨²âÊÔ»úÉϰ²×°SQL Server 2012,Ëù°²×°µÄ¹¦ÄÜÈçͼ8Ëùʾ¡£

ͼ8.SQL Server 2012°²×°µÄ¹¦ÄÜ
°²×°ÍêSQL Server 2012Ö®ºó,ÔËÐÐSQL ServerÅäÖùÜÀíÆ÷£¬Èçͼ9Ëùʾ¡£

ͼ9.ÔËÐÐSQL Server ÅäÖùÜÀíÆ÷
È»ºóÔÚSQL ServerʵÀýÖпªÆôalwaysOnÑ¡ÏÈçͼ10Ëùʾ.
ͼ10.¿ªÆôAlwaysOn
δÍê´ýÐø¡.
×÷Õß ËÎ ½£