??? ???? ?????? ???? ??????? ????? ???? ????? ??? SQL Server

???? ??? ??????? ????? ????? ??? ??????? Microsoft SQL Server ??? ???? ???? ?????? ????? ???.

???

• ??? ??? ?????? ???? ???? ?????? ????? ??? SQL Server ??? ???? ????? ???? ????? ????? SQL Server. ???? ??? ?????? ???? SQL. ????? ??? ?????? ?? ?????? ????? ????? ?????? ??? ????? ?????? ??? ?? ???? ?? ??? ??????.
• ????? ????? ????? ?? ????? ???? ???????? ?? ???? ???? ?????? ????? ?????? ?????? ???? "????? ??????" (Cluadmin.exe)? ?????? ????? ?? ????? ????? ???? ???????? ?? ???? ???? ?????? ????? ?????. ??? ???? ???? ???? ????? ?? ????? ???? ???????? ???? ??? ???????? ???????.
• ?? Microsoft SQL Server 2008 ?????????? ??????? ???? ???? ?????? ???? ??? ???? ????? SQL ?????? ??? ????? ???????? ?????????. ???? ??? ???? ????? SQL ???? ???????????. ????? ??? ?????? ?? Microsoft SQL Server 2005. ?? SQL Server 2005? ?????? SQL Server ???? ???????????.

????? ???????? ????????? ??? ???? ?????? ????? ??? SQL Server

?????? ????? ????????? ??????? ?? ??? ?????? ??? SQL Server 2008 ?????????? ??????.

1. ??? ??? ????? "?????????"? ???? ?? ?? ???? ???? ????? ???????? ????????? ????? SQL Server ?????? ???????? ?????. ????? ?? ??? ???? ???? ????? SQL Server ?????? ????? ????? ??????:
   ???? cluster.exe
   ???? ??????? ?????? ??? ???:

   Resource                          Group                             Node              Status
   --------------------              --------------------              ----------        ------
   Cluster Disk 1                    Cluster Group                     NODE1             Online
   Cluster Disk 2                    SQL Server (INST1)                NODE1             Online
   Cluster Disk 3                    SQL Server (INST2)                NODE1             Online
   Cluster Disk 4                    Available Storage                 NODE1             Online
   Cluster IP Address                Cluster Group                     NODE1             Online
   Cluster Name                      Cluster Group                     NODE1             Online
   SQL IP Address 1 (SQLVS1)         SQL Server (INST1)                NODE1             Online
   SQL Network Name (SQLVS1)         SQL Server (INST1)                NODE1             Online
   SQL Server                        SQL Server (INST1)                NODE1             Online
   SQL Server Agent                  SQL Server (INST1)                NODE1             Online
   SQL IP Address 2 (SQLVS2)         SQL Server (INST2)                NODE1             Online
   SQL Network Name (SQLVS2)         SQL Server (INST2)                NODE1             Online
   SQL Server                        SQL Server (INST2)                NODE1             Online
   SQL Server Agent                  SQL Server (INST2)                NODE1             Online
   

   ?? ??? ??????? ????? ??????? ??????? ??????? ?????? ????? ???????? ????????? ??? ???? ??? ???? ????? SQL:
   • ???? cluster.exe "??? ???? ????? SQL (SQLVS1)"/listowners > c:\SQLVS1_list_of_owners.txt
   • ???? cluster.exe "??? ???? ????? SQL (SQLVS2)"/listowners > c:\SQLVS2_list_of_owners.txt
2. ?? ?????? "????? ?????"? ??????? ???? ??? ???? ????? SQL ???????? ?????? ??? ????? ?? ????? ???????? ????????? ?? ?????? ???? ?????? ????? ????? ???? ???? ????? ?????????. ????? ????? ?????? ????? ?? ???????? ?????????. ??????? ??? ????? ????? ???? ???? ???????? ?? ???????? ????????? ????? ??????? ????? ????? ??????? ???.
   
   ?????? ???? ???? ?????? ??? ????? ?? ???????? ????????? ?????? ??? ??????? ???? ?????.
3. ??? ????? ????? ?? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????? ????? ??????? SQL Server ??? ????? ???? ??? ???????? ?? ?????? 2. ?????? ??????? ??? ?? ???? ??? ?????? ?? ???????? ?????????? ???? ??????? ???? ??? ??????? ??? ???? ??????? ???? ??? ???? ??????.
   
   ?????? ??? ???? ??? ?? ????? ?????? ???? ???? ?????? ??????? ??? ???? ?????? ??? ??? ??????? ????? ???? ??? ???? ???? ??? ????? ???????. ????? ??? ?? ???? ??? ?????? ?? ????? ?? ????? ????? ????? ???? ?? ???? ????? ??? ????? ???????? ???????? ???? ??? ?????????.
4. ??? ????? ??????? ??? ????? ???? ??? ??????? ?? ???????? ?????????? ?????? ???? ??? ???? ????? SQL ?? ???? "????? ??????" ?????? ????? ??????? ??? ???? ??? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
   
   ?????? ?? ??? ???? ????? ????? ?????? ??????? SQL Server ??????? ?????? ????? ???????? ????????? ???? ??? ???????? ??? ????? ???????. ???? ?? ????? ????? ???? ?? ??????? ?????? ?? ??????? ?????? ??.
5. ???????? ??? ???? ??? ???? ????? SQL? ????? ?? ?????? ?????? ?????? ?? ????????? ?? ????? Windows Server 2008? ??? ?? ?????? ??? ???????? ?? ??????? ?? ?????? ??? ????? ???? ?? ???????.
6. ???? ?? ?? ???? ????? SQL Server ??? ?????? ??? ???? ???? ?????.
7. ?? ?????? "????? ?????"? ??????? ???? ??? ???? ????? SQL ?????? ????? ???? ?? ??? ??????? ?? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
8. ????? ??????? SQL Server ??? ????? ???? ??? ???????? ?? ?????? 7.
9. ??? ?????? 4 ?????? ???? ????? ???? ?? ??????? ??? ???????? ????????? ????? ???? ?????? ????? ????? ???? ??? ???????.
10. ???? ?? ?? ???? ???????? ??? ??????? ??? ??? ?????. ???? ??? ???? SQL Server ??? ????? ?? ???? ????????.

????? ????? ??????? SQL Server ??? ???? ?????? ????? ??? ?? ??????? ????? ?????

?????? ????? ????????? ??????? ?? ??? ?????? ??? SQL Server 2008 ?????????? ??????.

?????? ??????? ???? ??? ??????? ??? ?????? ????:

????????? 1: ????? ??????? ??? ???? ????? ??????

?? ??? ?????????? ??????? ?????? ????? ??????? ?? ??? ????? ???????? ???? ??? ???????? ?? ?????? ?????. ????? ????????? ??????? ??? ???:

1. ??? ?? ???? ?????? ?????????? ???? ?? ?? ???? ???? ????? ???????? ????????? ????? SQL Server ?????? ???????? ?????. ????? ?? ??? ???? ???? ????? SQL Server ?????? ????? ????? ??????:
   

   cluster.exe resource 

   ???? ??????? ?????? ??? ???:
   ???? ???? ?????? ???????-----------
   ??? ?????? 1 ?????? ???? ????????? NODE1 ??? ???????? ???? ????? 2 SQL Server (INST1) NODE1 ??? ????????
   ???? ????? 3 NODE1 ??? ?????? NODE1 SQL Server (INST2) ??? ???????? 4 ????? ??????? ???????? ??? ????????
   ?????? ???? ???????? ????? IP ?????? NODE1 ??? ???????? ?????? ?????? ??? ?????? NODE1 ??? ???????? SQL ????? IP 1 (SQLVS1)
   ???? SQL SQL ??? ???????? (INST1) NODE1 ??? ?????? (SQLVS1) SQL Server (INST1) NODE1 ??? ???????? ???? ???? SQL Server
   (INST1) NODE1 ??? ???????? SQL ???? SQL Server (INST1) NODE1 ??? ???????? SQL ????? IP ????? 2 NODE1 ???? SQL (SQLVS2) (INST2) ??? ????????
   SQL ?????? ??? (SQLVS2) SQL Server ?? ???? SQL ??? ???????? NODE1 SQL Server (INST2) (INST2) NODE1 ??? ????????
   SQL ???? ???? SQL Server (INST2) NODE1 ??? ????????
   
   ?? ??? ??????? ????? ??????? ??????? ??????? ?????? ????? ???????? ????????? ??? ???? ??? ???? ????? SQL:
   • ???? cluster.exe "??? ???? ????? SQL (SQLVS1)"/listowners > c:\SQLVS1_list_of_owners.txt
   • ???? cluster.exe "??? ???? ????? SQL (SQLVS2)"/listowners > c:\SQLVS2_list_of_owners.txt
2. ?? ?????? "????? ?????"? ??????? ???? ??? ???? ????? SQL ???????? ?????? ??? ????? ?? ????? ???????? ????????? ?? ?????? ???? ?????? ????? ????? ???? ???? ????? ?????????. ????? ????? ?????? ????? ?? ???????? ?????????. ??????? ??? ????? ????? ???? ???? ???????? ?? ???????? ????????? ????? ??????? ????? ????? ????? ??? ???????.
   ?????????? ???? ?????? ??? ????? ?? ???????? ????????? ?????? ??? ??????? ???? ?????.
3. ??? ????? ????? ?? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????? ????? ????? SQL Server ??? ????? ???? ??? ???????? ?? ?????? 2. ?????? ??????? ??? ?? ???? ??? ?????? ?? ???????? ?????????? ???? ??????? ???? ??? ??????? ??? ???? ??????? ???? ??? ???? ??????.
   
   ????????? ???? ??? ?? ????? ?????? ???? ???? ?????? ??????? ??? ???? ?????? ??? ??? ??????? ????? ???? ??? ???? ???? ??? ?? ???? ?????? ???????. ????? ??? ?? ???? ??? ?????? ?? ????? ?? ????? ????? ????? ???? ?? ???? ????? ??? ????? ???????? ???????? ???? ??? ?????????.
4. ??? ????? ??????? ??? ????? ???? ??? ??????? ?? ???????? ?????????? ?????? ???? ??? ???? ????? SQL ?? ???? "????? ??????" ?????? ????? ?????? ??? ???? ??? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
   
   ?????? ?? ??? ???? ????? ????? ?????? ??????? SQL Server ??????? ?????? ????? ???????? ????????? ???? ??? ???????? ??? ????? ???????. ???? ?? ????? ????? ???? ?? ??? ?????? ?? ??????? ?????? ??.
5. ???????? ??? ???? ??? ???? ????? SQL? ?????? ??? ?????? ??????? ??????? ?? ????????? ?? ????? Windows Server 2008? ??? ?? ?????? ??? ???????? ?? ??????? ?? ?????? ??? ????? ???? ?? ???.
6. ???? ?? ?? ???? ????? SQL Server ??? ?????? ??? ???? ???? ?????.
7. ?? ?????? "????? ?????"? ??????? ???? ??? ???? ????? SQL ?????? ????? ???? ?? ?? ??? ?? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
8. ?? ?????? ????? SQL Server ????? ???? ??? ???????? ?? ?????? 7.
9. ??? ?????? 4 ?????? ???? ????? ???? ?? ??? ??? ???? ??? ???????? ????????? ????? ???? ?????? ????? ????? ???? ????? ???.
10. ???? ?? ?? ???? ???????? ??? ??????? ??? ??? ?????. ???? ??? ???? SQL Server ??? ????? ?? ???? ????????.

????????? 2: ??? ?? ????? ???????? ????? ??????? ???? ????? ??? ????? ???.

?? ???? ???? ??????? ?????? ???? ??? ?? ???? ?????:

?????????????? ??????? ????? ?? ??? ????? ??????? ???? ??? ???????? ?? ?????? "????? SQL Server ???????? ????????? ??? ???? ?????? ????? ???" ?? ??? ??????? ???? ?? ????? ????? ????? ????? ?? ?????? ??? ?????.

?????????? ????? ?????-(??? ????? ??? ??????? ?? ???????? ????????? ?????)

?????? 1A: ???? ??? ???????? ???? ?????? ????? ???????.
?????? ??????? ??????:

1. ????? ??????? ??? ?? ???? ?? ????? ???????? ??? ???? ????? SQL ?????? ??? ???? "????? ??????" ???????? ??? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
2. ???? ?? ?? ???? ???????? ??? ??????? ??? ??? ?????. ???? ??? ???? SQL Server ??? ????? ?? ???? ????????.

???? 2A. ??? ????? ??????? ??? ??? ?????? ????? (??? ?? ???? ????? ?? ???????? ?? ??? ????? ?? Microsoft CSS) ???? ???? ????? ?? ??????? ?????? ??? ?? ?? ?????? ???????? ??????.

1. ?? ???? ??? ???? ????? ???? ?? ??????? ???? ???? ??? ????? ???????? ?????? ???? ????????? ?? ??????? ?? 3 ??? 10 ????? ????? ?? ??? "????? SQL Server 2008 ???????? ????????? ??? ???? ????? ?????" ?? ??? ??????? ??????? ????? ???????.
2. ??? ??? ????? ???? ??? ????? ?? ?? ????? ????? ??? ??????? ?????? ??????? ?????? ??????? ?????? ????? 1A ?????.

???? 3A. ?? ??? ?????? ??? ????? ??????? ??? ???? ????? ?? ????:

?? ??? ?????? ????? ??????? ????? ??????? ??? ??? ??????? ?????? ???? ?????? ??????? ??????? ????? ?????? ????????. ??? ????? ????? ??? ???? ??????? ??????? ?????? SQL Server? ???? ???? ????? ?? ??? ?? ??? ???????.

?? ???? ??????? ??????? ???????? ??? ?????? ?????? ???? ????? ????? ?? ????? ?????? ?????? ???? ???????? ?????? ??? ????? ??????? ??????? ?????? ????? 1A ?????.

????? ??????? ????? ??????: (??? ????? ????? ????? ?? ????? ???????? ??? ???? ??? ????? ???????? ????????? ?????? ??? ??? ????? ?? ????? ????? ?????? ?? ????? ???????? ?????????):

?????? 1B: ????? ?? ?? ??? ?????? ??? ??? ???????? SQL Server ?????? ??????? (?????? #5 ?? ????? ???????) ??? ????? ???????? ?? ??????? (SQL server ???? ????? ??? ???????? ??? ???? ??? ???? ???? ?? ??? ?????).

?????? ??????? ??????:

1. ?????? ?? ??? ??? ????? ????? ???? ?? ??????? ?????? ???????. ??? ??? ???????? ??????? ????????? ?? ????? ????? ?? ??? "????? SQL Server 2008 ???????? ????????? ??? ???? ????? ?????" ?? ??? ??????? ???????? ?? ????? ????? ?????.
   
   ???????? ????? ?????? ??????? ???????? ?? ????? ?????. ????? ??? ??? ????? ????? ??? ????? ???? ??? ??????? ?? ????? ?????? ??????? ????? SQL Server ??? ???????? ??? ?? ??? ???? ?????? ?????? ??????? ???????? ????? ??????? ???????? ???? ??? ???????? ?? ????? ??? ??????? ????? ????.
2. ??? ??? ????? ???? ??? ????? ?? ?? ????? ????? ??? ??????? ?????? ??????? ?????? ??????? ??????:
   1. ???????? ??????? ???? ??? ?????? ?? ????? ????? ???????? ????? ????? ??? ????? ???? ????? ??????? ??????? ???? ???? ????? ???? SQL.
   2. ????? ?????? ??? ????? "?????" ??? ???? ??? ???????? ????????? ???? ???? ????? ???? SQL.
      ????????? ?????? ???? ???? ????? ??? ?? ???? ????? ?? ????? ??????. ????? ???? ?? ??? ?? ????? ?? ????? ?????? ?? ?? ?????? ???.
   3. ??? ????? ???????? ?????? ???? ??? ???? ????? SQL ?? ???? "????? ??????" ?????? ??? ????? ??? ???? ??? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
   4. ???? ?? ?? ???? ???????? ??? ??????? ??? ??? ?????. ???? ??? ???? SQL Server ??? ????? ?? ???? ????????.

?????? 2: ??? ????? ??????? ??? ??? ?????? ????? (??? ?? ???? ????? ?? ???????? ?? ??? ????? ?? Microsoft CSS) ???? ???? ????? ?? ??????? ?????? ??? ?? ?? ?????? ???????? ??????.(???????? SQL Server ??? ???????? ??? ???? ????? ????? ????? ???? ?? ???????).

?????? ??????? ??????:

1. ?????? ?? ??? ??? ????? ????? ???? ?? ??????? ?????? ???????. ??? ??? ???????? ?????? ?? ??????? ?? ????? ????? ?? ??? "????? SQL Server ???????? ????????? ??? ???? ?????? ????? ???" ?? ??? ??????? ???????? ?? ???? ????? ?????? ???? ????? ?? ????? ?????? ????? ?? ??????.
   
   ?????????? ?????, ??? ?????? ????? ???????? ??? ???? ??? ???? ????? ?? ??? ??? ??? ??? ?????? ???? ??? ??????? ?? ????? ?????? ?? ?????? ???????? ?? ???????-????? ?? ????? ???????? ??????? ?? ????? ???? ?? ??????.
2. ??? ??? ????? ???? ??? ????? ?? ?? ????? ????? ??? ??????? ?????? ??????? ?????? ??????? ??????:
   1. ????? ??????? ??? ?? ?? ????? ???? ??? ??????? ?? ????? ?????? ??????? ??? ??????? ???? ??? ??????? ??? ???? ??????? ???? ??? ???? ??????.
   2. ?????? ???? ??? ???? ????? SQL ?? ???? "????? ??????" ?????? ????? ?????? ?? ????? ??? ???? ??? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
      
      ?????? ?? ??? ???? ????? ????? ?????? ??????? SQL Server ??????? ?????? ????? ???????? ????????? ???? ??? ???????? ??? ????? ???????. ???? ?? ????? ????? ???? ?? ??????? ?????? ?? ??????? ?????? ??.
   3. ???????? ??? ???? ??? ???? ????? SQL? ????? ?? ?????? ?????? ?????? ?? ????????? ?? ????? Windows Server 2008? ??? ??? ??? ???????? ?? ??????? ?? ?????? ????? ????? ?? ????? ??????.
   4. ???????? ??????? ???? ??? ?????? ?? ????? ????? ???????? ????? ????? ??? ????? ???? ????? ??????? ??????? ???? ???? ????? ???? SQL.
   5. ????? ??????? ??? ?? ?? ??? ????? ??????? ??? ??????? ???? ??? ??????? ??? ???? ??????? ???? ??? ???? ??????.
   6. ??? ????? ???????? ?????? ???? ??? ???? ????? SQL ?? ???? "????? ??????" ?????? ??? ????? ??? ???? ??? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
   7. ???? ?? ?? ???? ???????? ??? ??????? ??? ??? ?????. ???? ??? ???? SQL Server ??? ????? ?? ???? ????????.

?????? 3B: ???? ??? ???????? ???? ?????? ????? ?????: ?????? ??????? ??????.

1. ????? ??????? ??? ?? ????? ???? ?? ?????? ?? ??????? ?? ????? ?????? ??????? ??? ??????? ???? ??? ??????? ??? ???? ??????? ???? ??? ???? ??????.
2. ?????? ???? ??? ???? ????? SQL ?? ???? "????? ??????" ?????? ????? ?????? ?? ????? ??? ???? ??? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
3. ?????? ?? ??? ???? ????? ????? ?????? ??????? SQL Server ??????? ?????? ????? ???????? ????????? ???? ??? ???????? ??? ????? ???????. ???? ?? ????? ????? ???? ?? ??????? ?????? ?? ??????? ?????? ??.
4. ???????? ??? ???? ??? ???? ????? SQL? ????? ?? ?????? ?????? ?????? ?? ????????? ?? ????? Windows Server 2008? ??? ??? ??? ???????? ?? ??????? ?? ?????? ????? ????? ?? ????? ??????.
5. ???????? ??????? ???? ??? ?????? ?? ????? ????? ???????? ????? ????? ??? ????? ???? ????? ??????? ??????? ???? ???? ????? ???? SQL.
6. ????? ??????? ??? ?? ?? ??? ????? ??????? ??? ??????? ???? ??? ??????? ??? ???? ??????? ???? ??? ???? ??????.
7. ??? ????? ???????? ?????? ???? ??? ???? ????? SQL ?? ???? "????? ??????" ?????? ??? ????? ??? ???? ??? ????? ???????? ????????? ?? ???? ???? ?????? ????? ?????.
8. ???? ?? ?? ???? ???????? ??? ??????? ??? ??? ?????. ???? ??? ???? SQL Server ??? ????? ?? ???? ????????.