???? ID: 260758 - ????? ???????: 02 ?????? 2010 - ??????: 2.0

????? ???? ?? ???????? - SQL Server 2000 - failover clustering

?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

?? ????? ??

??? ?? ??????? ???? | ??? ?? ??????? ????

??????

?? ???? ??? SQL Server 2000 ??????????? ??????? clustering failover ?? ???? ??? ????? ???? ???????? ?? covers ???

Failover clustering ?? ???? ??? ???????? ????? ???? ?? ????????, ?? ??? "?????? Clustering FAQ" ??? SQL Server 2000 ???????? ?????? ?????? ??????? SQL Server 2000 ?????????? ???????? ??? ?? ???? SQL Server ???????? ?????? ????

???? ???????

?????? ?? ?????

  1. ??????: ??????? ??????? ?????? ?? ??? ????? ??????-??????? ?????????? ?? ????? ???? ?? ???? ???

    ?????: No.???????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
    171052  (http://support.microsoft.com/kb/171052/ ) Microsoft ??????? ????? ??? FT ?????????? ??? ??????? ???? ??
  2. ??????: SQL Server 2000 ?????? ??? ?????? clustering ???

    ?????: SQL Server 2000 clustering ?????? ???? ??? ?????? ??; ?? failover ?????? ?????? ????? ??? ??? ?????? ?????, ?? ??? ???? ?????????? ?? ??? ???? ??? ???? ??????? ????? ?? ???, ????????? ?? ??? balances ?? ???????? ???
  3. ??????: ?? SQL Server 2000 ?????-??? ??? ?????? clustering?

    ?????: ????
  4. ??????: MSDTC ????? ?????? ?? ??? ??? ????? ???? ?? ??? clustering SQL ????? ?? ??? ???????? ???? ?? ??? ?????? ???? ???

    ?????: No. ??? ???? ???? ??????? ?? ?????? ?????? ???? ?? ?????? ???? MSDTC ?????? ??? ??? ?? ???? ??? ?? ????? ?? ????? ???? ?? ??????????? (????????/transactional ?????? subscribers ?????/?????????? ?? ???) ???? ?? ??? ????????, MSDTC ?????? ??? ???? ??????? ?? ??? ????? "Distributed ????????? ???????????" SQL Server 2000 ???????? ?????? ????
  5. ??????: ?? ???? ??? ???????? Microsoft SQL Server 6.5 ?? 7.0 SQL Server 2000 ?? ??? ?? 6.5 ?? 7.0 ??????? ????? ?? ???? ??????? ?? ??? ???

    ?????: ??? ???? SQL Server 6.5 ?? 7.0 ????? ???? ??????? ?? ??? ??, ?? SQL Server 2000 ?? ??? ????? ?? ???????? ???? ?? ??? ????? ????? ?? ???? ?????:

    1. ????? ????? ?? SQL Server 6.5 ?? 7.0 clustering ????????
    2. Microsoft ?????? ?????? Coordinator (MS DTC) ?? ??? ????? ?? ??? ?? ???? ??????? ???? SQL Server 2000 ???????? ?????? ?? "?????? Clustering ??????????" ??? ??? ????? ???? ??? ???
    3. ????? ??????????? ??? ???????? ??? ?? SQL Server 2000 ??????? ?????
    ???? ??????? ?? ??? SQL ??? ????? ???? ????? ????? ???????? ??????:
    • ?? SQL Server 6.5 ??????/passive failover ??????? (?????) ??? ???????? ???? ????
    • ?? SQL Server 6.5 ??????/?????? failover ??????? (?????) ??? ???????? ???? ????
    • ?? SQL Server 7.0 ??????/passive failover ??????? (?????) ??? ???????? ???? ????
    • ?? SQL Server 7.0 ??????/?????? failover ??????? (?????) ??? ???????? ???? ????
  6. ??????: ????????? ???? ?????????? ??????? ??? SQL Server 2000 ?? ????? ?? ??? ?????? ???? ???

    ?????: ???? ?? ??? ??????? ????????? ??????????? ?? ????????? ??????????? ??????? ?? ???? ?? ??? Microsoft ??????? ????? ?????????? ?? ???????????? ??????

    ???:????? ?? ???-??? ??????? ?????? ????? ??????? ???? ???? ?? ???? ??????? "???????" ???? ?? ????? ?? ??? ????????????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
    309395  (http://support.microsoft.com/kb/309395/ ) ????? ?????????, ????????? ?????? ???? ???, ?? Windows ????? ?????? ?? ??? Microsoft ?????? ????
  7. ??????: SQL Server 6.5 ?? ???? ??????? ?? ?? ??? ?? ??????? 7.0 ?? SQL Server 2000 ??????? ???? ?? ???? ??? ???

    ?????: No. ??? ??????? ??? ??? ?? ??? ?? SQL Server ?????, ?? ??? ?? ?? ?? ??????? ???? ?????? ???
  8. ??????: ???? ???? ??? ???? SQL Server 2000 ?????? ?? failover ?????? ?????? ???? ?? ????

    ?????: SQL Server ????? ??????? ??? ???????? ???????? ?? ??????? ????? ?? SQL Server ????????? ?? ?? ?? ???????? ?? ??????? ???? ??, ?? ?????? ??????? ???? ????????? ??????? ????? ?? ??????? ???? ??? ????????? ???????? ??????? ??? ?? ??????? ??? ?? ???? ?? ??? ??????? ??? ????? ?? ?? ??? ??? ??? ??????? ?????? ????? ??? common ?? ??? ????? ??????? ??? ????????? ???? ?????? ????
  9. ??????: ?? ???? ??? ?? ???? SQL Server ???? ?????? ?? ???? ???? ?????? ?? ??? ??? ?? ???? interpreting ??????? ?????

    ?????: Microsoft Windows NT ??????????? ???????, Windows 2000 ????? ????? ?? Microsoft Windows 2000 ???? ?????? ?? ??? ??? ?? ?? Cluster.exe ????????? ?? ????? ???? ?????? ?? SQL ????? ?? ??? ???? ?? ??? ???? ????? ??? Cluster.exe ??????? ??????? ????? ??, ?? Microsoft Windows NT ??????????, Microsoft Windows 2000 Professional, ?? Microsoft Windows 2000 ????? ????? ????? ???????? ?? ??? ??????? ?????????? ?? ???? ???????????? ????????? ??????? ???? ?? ??? ?? ????? ?? ???? ??? ?? ?? ??? ?? ??? ??? ??????? ???? ??? ??? ?? ???? ?? ??? ??? ???????? ??????????? ???
    cluster [cluster name] RESOURCE [resource name] /option
    						
    ????? ??????? ????????, ??? /option ????? ?? ??????????? ????????? ???? ???

    ????? ?? ??? ??????? ?????? ??? "/ ??????" ?? "/ ???????"? ?? ?? ?????? "??? ??????? mssqlserver" ???? ?? ?????? ??? (???? ?????? ?? SQL ????? ?? ??????? ???? ?? ??? ????) ?? "net stop mssqlserver" (???? ?????? ?? SQL ????? ?? ??? ???? ?? ??? ????) ???-virtualized ????? ?? ??? respectively. ?? ?????? ????, SQL Server ????? ?? SQL Server ???????? ?? ?? ????????? ?? ??? ?? ???? ????

    ????? ?? ?? ??????? ???????? ?? ????? ???? ???? ?? ??? ?????? ???: ?? SQL Server 2000 ?????? ??????? ??? ??????? ??? ?? "SQLCluster" ?? ?????? ??? "VirtualSQL" (???? 'VirtualSQL' ?? ??? ?? SQL Server 2000 ??????, ???? ??????? ??????? ??? ??????) ?? ???:
    cluster "SQLCluster" resource "VirtualSQL" /offline
    					
    SQL Server 2000 ?????? ?????? ???? ???? ???:
    cluster "SQLCluster" resource "VirtualSQL" /online
    					
  10. ??????: ???? SQL Server 2000 ??????? ????? ?? ??? ????? ??????? ??? ?? ???? ??? ?? ??? ???????? ?? SQL Server 2000 ?? ?? ??????-???? ??????? coexist ???

    ?????: ???? ?? ?? ???????? ?? SQL Server 2000 ??????? ????? ?? ??????-???? ?????????? ?? coexist ?? ???? ???? ???????, ???? SQL Server 2000 ??????? ????? ???? ???? ?? ??????? ??? ???? ????? ?? ???? ???????? ?? ????? ???? ?? ??? ???? ??? ?? ?? ??? ??? ?? SQL Server 2000 ?? ?? ?? ???? ???????? ?? ?? ???????? ?? ????? ??? ????? ???????? ?? ????? ????:
    • ???? SQL ????? ??????? ??? ???? ????? ??? ?? ????? ???? ?????? ??? ?? ??????? ??????? ??? ????? ??? ??? ?? ??? ?? ???????? ??? ?????? ????, ??? ??? ????????? ???????? ?? ???????????? ????? ???????? ??? ?? ??? ?? ?? ???????? ?? ?? ???????? ?????? ?? ????? ??? ???
    • ??? ??, ?? ??????? ??? ???????? ?? ?????? ??? ???????? ?? ??? ???????? ?? ???????? ?? ???? ???? ????????? ???? ?? ?? ???????? ?? ????? ???

??????

???????? ??????? ?? ???, ????? ???? ???????? ?? ????? ?? ?????? ?? Microsoft ???????? ??? ?????::
294209  (http://support.microsoft.com/kb/294209/ ) ???: ????? ?? ???? SQL failover ??????? ?? ??? ????? MSDTC ?? ???? ?? ??? ???? ????
298568  (http://support.microsoft.com/kb/298568/ ) ???? ???: ??????? ???? ?? ??? ?????? ??????? ?? ?? ??????? SQL Server 2000 ???????
243218  (http://support.microsoft.com/kb/243218/ ) SQL Server 2000 ??????????? ??????? ?? ??? Microsoft ??????? ????? ?? ??????? ????
Clustering SQL Server 2000 ??????
HTTP://TechNet.Microsoft.com/en-us/library/cc917693.aspx (http://technet.microsoft.com/en-us/library/cc917693.aspx)

???? ?????? ???? ?? ??? ??? ????? ???? ???? ?? ?????? Microsoft SQL Server ???? ?? ????:Microsoft SQL Server ?????? ???? (http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server)

?? ?? ???? Microsoft SQL Server ???????? ?????? ?? ???? ??? ???????? ???? ?? ??? ?? ????:SQLKB@Microsoft.com (mailto:sqlkb@microsoft.com)

???? ???? ???? ??:
  • Microsoft SQL Server 2000 Enterprise Edition
??????: 
kbhowto kbclustering kbinfo kbmt KB260758 KbMthi
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:260758  (http://support.microsoft.com/kb/260758/en-us/ )