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

???? ???????: 273673 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??? ????????? ??? ??????? ???? ?????? ??????? ?? Microsoft SQL.
???? ??? ?????? | ????? ???????

??????? ????

??? ??? ?????? ?? ????? ?? ?????? ??? ????? ?????? ?? ????? ????? ???????. ??? ???? ?? ???? ?????? ????? ?? ???? ????? ????? ?????? ??? ?????. ????? ???? ?? ???? ??????? ??????? ??????. ?????? ??? ??????? ??????? ??? ???? ???????? ?? ????? ??? ??????. ?? ????? ??????? ????? ?? ???? ???? ?????. ?????? ??? ???? ?? ????????? ??? ????? ??? ???? ???????? ?? ????? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
322756
(http://support.microsoft.com/kb/322756/ )
????? ??? ???? ???????? ? ??????? ??????? ?? Windows


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

???? ???? ?????? ?? Microsoft "(MSCS) ?????? ??? ?????? ??? ????? ????? ??????? ???? SQL ??????. ?? ????? ??? ????? ???? ??????? ?????? ???????? MSCS. ??? ???? ????????? ???????? ??? ???????? (??? ???? ??????? ?????? ????? ???????? ? ??? Microsoft SQL Server) ????? ????? ??????? ?????? ???? ??? ??? ?????? ?? ??? ????? ????? ???? ????? ????? ????????? ???? ????. ??? ????? ????? ???? ?????? ?? MSCS ?????? ??????. ??? ???? ????? ????????? ?? ??????? ????? ???????? "?" ????? ??????? ?? ????????.

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

????? ????? ????? ? ???? ??????? ????? SQL Server ??????? ?????? ?? ??? ????? ??????? ?????? ????????. ??? ??? ????? ?????? ??? ?????? ???? ?????? ? (??? ???? ??????? ????????? ???? ?? ??????? ???????? ???? ??????? ?????? Microsoft [IIS] ???? ??????) ?????? ???? ?????? ??????? ????????. ??? ?????? ??????? ???? ???? ????? (??? ???? ??????? ???? ?????? ?????? ?? ??????? ???? ?????, ????????? ???????? Transact-SQL ?? ?????? ?? tempdb) ? ????? ????? ??? ????? ??? ??????. ?? ??? ???????? ??? ????? ????? ???? ?????? ???????? ???? ?? ??????? ??? ?????, ?? ????? ????? ?? ?? ???? ???? ????? ???????? ????? ????? ????? ????? ?? ??? ??????. ??? ????? ??? ?????? ?? ??? ?????? ??? ???? ????? ???.

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

??? ??? ???? SQL Server ?? ???? ???? ??????? ?? ??? ????? ??? ????? ??????? TCP. ??? ?? ????? ????? SQL Server ?????? ???? ????? (?????? Kill.exe) ? ??? ????? ??? ????? ???????.

?? ???? ??? ??? ????? ?????? ??? ??? ??????? ?? ???? ????? ???? ??????? ?? ???? ??????? ?? ??? (0).

??? ?? ??? ??????? ???? ???? ??????? ?? ???? ???? ??? ????????? ?? ???? ESTABLISHED ??? ???? ????? ???. ????? ????? ??? ????? ????????? ???????? ????? ?? ??? TCP ?????? ?? ??? ????????? ???? ??? ?? ???? ??? ????????? ?????? ???? ????. ???? ????? ????? ?? ???? ?? TCP ????? ????? ????? ??? ????? ?????? ? ??? ????????? ???????? ???????? ?????? ??? ????? ????????? (?? ???? ??????? ???? ?????? ??? ??????) ? ?? ???? ????? ??????? ?? ????????? (???? ?????).

??????? ??? ??????? ?? ????? ????? ???? ????? ???? ????????? ??? ??? ????.

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

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

Start\Programs\Administrative Tools (Common)\Cluster Administrator\Group\Failover\Properties
?????? ?????????? "????? ????? ????????" ????? ????? 10 ?? ???? 6 ???? ??? ???? ????? ??? ??? ???? ????????. ??? ???? ????? SQL Server ?????? ???? ???? ?????? ?? ???? ????? SQL Server ??? ???? ???? ???????? SQL Server ? ?? ?? ??????? ?? ???? ?????? ????? ??????? ??? ??? SQL Server ???????? 900 ? ???? ??????? ???? ?? ????????. ??? ???? ???? ??????? ??????? ????? ??????? ????? ?????? ? ????? ?????? ????? ????? ??????? ????? ?????? ?????? ?? ??? ????? ???????? ??? ??????? ???? ?????.

???????? SQL Server 6.5 ? SQL Server 7.0

SQL Server 6.5 ? SQL Server 7.0 ???? ?????? ??? ?? ???? ?? ????? "???? ??? ????? ???????" ???????.

??? ????? SQL Server 7.0 ????? ????? ????? ????? IP ???? ??? SQL Server 7.0 ??? ?? ?????? ??? ????? ?????? ??? ?? ?????? ?????? ??????. ??? ?? ???????? ?? ????? "?????? ????? ??? TCP/IP ?????" ?? ????? "????? ????? Microsoft" ???????:
254321
(http://support.microsoft.com/kb/254321/EN-US/ )
INF: Do's ???? SQL ?????? ????????, Don'ts ?????????? ?????

???????? Microsoft SQL Server 2000

????? SQL Server 2000 ??? ?????????? ?? ???? ?? ??????? SQL Server 6.5 ? SQL Server 7.0.

??????? ?????? SQL Server 2000

???? ???????? ???? ???? ???????? ??? ???? ????????. ???? ?????? ??? ???? ??? ?? ???? ??????? ?? ????? ?????? ???? ??? ???? ??? ????? ?????? ?? ???? ????? ??? ??? (0) ? ?? ?? ????? ?????? ??? ??? ??????. ?????? ?????? ??? ??? ??????? ??????? ?? ??? ?????? ?? ???.

??? ?? ????? ???? ??????? ??? ???? ???????? ??? ?????? ?? ??????? ??? ?????? ?????????? ??? ??? ????? ?????? ?????? ???? ???.

?? ???? ????? ???? ???? ????? ??????? ?? ??? ??????? ???????? ?????? ???????? ???? ???? ??? ??????? ??? TCP/IP ??? ?????? ?? ???? ???????.

????? ??????? ??? ?????? ??????? ?? ?? ?????? ?????? ???? ???? ?? ??? ??? ???? ??? ???????.

??? ????? ??????? ??????? ??? ????? ??????? ?????? "LastConnect" ?? ????? ??????? ???:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\supersocketnetlib\lastConnect
???? ??????? ??? ???? "?" ??????? ???????? ?? ??????? ??? ?? ???????.

????? ?????? ?????? ??????? ??????? ??????? ??? ?? ????? ??? ??? ??? ??? ?? re-negotiates ????????? ???????. ?? ???? ??? ??? ?? ????? ??? ?????? ???? ??? ????? ?? ??? ??? ???? ???????? ?? re-assigned ???? ??? ???? ??? ?????????.

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

???? ???? ??? ???? ?? ??? ??? ?????:
  1. ??? ?????? ?? ????? ??????? ?????? killed (???? ????? ????? ??????? "??????" [spid]) ?? ??? ?? ???? (AV) ?? ??? ??? ????? ???? ??????? ?? ??? ??? ???? ????????.
  2. ????? ?????? ?? ??? ?? ??????? ??????.
  3. ????? ????? ??????.
?? ?? ??? ????????? ???????? ????? ???? ??? ?????? ??? ???? ????????? ??????.
  1. ?? ???? ??? ???? ?????? ????? ????? ??? ??? ????? ?????. ????? ?????? ??? ?????? ?????? ??????? ?? OSQL ????? ??????? ????? ?????????? ?? ????? ?????? ????? SQL Server. ????? ?????? ?? ???? ????? ??? ODBC.
  2. ??? ???? ???? ???????. ???? ????? ?????? ?????? ???????? ??? ????? ????? ?? ????? ???????.

    ?? ???? ?? ????? ????? ??????? ?????? ????? ??????? ???? ????? ?? ?????? ???? ???? ????????.

    ?????? ??? ?????? ??? ?????? ??? ????? ?????? ???? ????? ??????. ????? ?????? ????? ???? ????????? ?????? "???????? ??????".

    ?? Microsoft Windows 2000 ?????? Alive ??? ????? ?????? ??? ?????? ??? ????? ??? ???. ???? ???????? "???????? ??????" ??? ????? ??? 30 ?????. ??? ???? ??? ???? ??????? dies ???? ??? ????? ?? 30 ????? ? ?????? ????? ????? ????? ??????. ?? Microsoft Windows NT 4.0 ???????? ?????? ?? ???? ????? ??? ????? ??? ???. ???????? Alive ??? ????? ????????? ?????? ???????? ??????? ??? ???? ????????? ??? ??????.

    ?????? ??????? ???? ??? ???? ?????:
    KeepAliveTime\REG_DWORD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters 30000

    KeepAliveInterval\REG_DWORD HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters 1000
  3. ??? ??? ?????? ????? ????, ????? ?????? ????? ?????? ??????. ??? ???? ??? ??? ?? ???? ??? ?????? ?????? kills ?????? ??????? ???? ??????. killing ?????? ??????? ?? ???? ????? ??? ???? ????? ??? ?????? ??? ??????. ???? ?? ????? ????? ??? ????? ????? ???; ??? ???? ???? ????? ????? ????? ????? ???:
    "??? ??? ??? ?????, ?? ???? ?? ????? ??????? ?????? ??????".
    ??? ????? ??? ????? ?????? ODBC ??? ??? (0) ?? ??? ?????? ???? ??? ????? ?????? ??? ??? ??????.
???? ??? ?????? | ????? ???????

?????

?????? ??? ???? ?? ????????? ??? ???? ???? SQL Server ??????? ?? SQL Server 2005 ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms189585.aspx
(http://msdn2.microsoft.com/en-us/library/ms189585.aspx)
???? ??? ?????? | ????? ???????

???????

???? ???????: 273673 - ????? ??? ??????: 24/?? ??????/1428 - ??????: 7.3
????? ???
  • Microsoft SQL Server 6.5 Enterprise Edition
  • Microsoft SQL Server 7.0 Enterprise Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
????? ??????: 
kbmt kbhowto kbsql2005cluster kbclientserver kbinfo KB273673 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????273673
(http://support.microsoft.com/kb/273673/en-us/ )
???? ??? ?????? | ????? ???????

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

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