[SDP 3][ab09ed03-7576-425f-aae0-8f36c0e8c662] SQL ????? ??????????? ????? ???????? ?????? ???????? ???????

???? ?????? ???? ??????
???? ID: 2871695 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

Microsoft SQL Server ??????????? ????? ???????? ?? ??? Windows Server 2003 R2, Windows Vista, Windows Server 2008, Windows Server 2008 R2, Windows 7, Windows 8, Windows 8.1, Windows Server 2012 ?? Windows Server 2012 R2 ?? ?????? ???? SQL ????? ?? ??? ??????????? ???????? ?? ?????? ??? ?????? ?? ??????? ??????? ????? ???? ??? SQL ????? ??????????? ????? ??????????? ?? Microsoft SQL Server ???????? ?????? ?? ??? ????? ??????? ??????? ??????? ???? ???

SQL ????? ??????????? ????? ??????????? SQL Server ?? ????? ????????? ?? ?????? ???? ??:
  • SQL ????? 2005
  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012

???? ???????

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

?????? ???????? ?? ???????? ?????? ?? ???? ?? ????? ????? ?? ????? ?? ??? ?????????? ????? ???? ???? Diagnostic ???????? ??? ?? ?? ?????????? ?? ??? ???? ???????? ?? ???? ????? ?? ????????? ???? ??? ??? ?? ???? ?? ?? ??????? ???, ?? ??????? ????? ??, ??? ?? ???? ?? ?? ???????? ?? ?????? ???? ???, ?? ?????????? ??????? ???? ?? ??? ??? ???? Microsoft ???????? ?????? ?????? ???? (MATS) ?? ?????? ?????????? ?? ??????? ?? ???? ???? Windows PowerShell ?? ?????? ???????? ?? ????? ???? ??, ?? ?????? ?? ???, MATS ??? ???????? ??? ?? ??????? ?? ?????? ???? ??????? ?? ???, ????? ???? ?? Microsoft ???????? ??? ?????:
2598970 Microsoft ?? ???? ??? ??????? ???????? ?????? ?????? ?????? ?? ??????? ??????????? ??????

?????? Windows ??????

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

SQL ????? ??????? ??????????


SQL ????? ??????????? ????? ??????????? ???? ?? ??? ?? ??????? ????? ????? ?? ?? ???????? ?? ??????? ?? ?? ??? ???????? SQL ????? ??? ???? ??????? ????????? ?? ??? ?? ??? ???, ??????? SQL ????? ????????????, ?? ????? "??????." ?? ???? ??? ??????? ??????? ???? ?? ??? ??????? ????? ???? ?? ?? SQL ????? ?? ???????? ???????? ?? ??? ?????? ???? ?? ??? SQL Server ??????????? ????? ??????????? ?? ?????? ???? ?? Windows ?????????? ?? ????? ???? ??????? ??????? ??? ?? ???? ??? ???? ?? ??? ????? ??????? ??????? ?????? ????? ?? ???, Windows ????? ????? ??? ??????? sysadmin ?? ????? ?? ?? ???? SQL Server ??????????? ????? ??????????? ????????? ?? ??? ?? ?? ?????????? ???? ?????:
  • SQL ????? AlwaysOn ???????????? ??????
  • SQLDIAG ???? ?????? ?????????

Windows ?????? ??????? ?? ??? ??????

SQL ????? AlwaysOn ???????? ???? ??????????? ?? ????? SQL Server ??????????? ?? ????? ???? ?? ???, ?? ?? ?? ???? ??????? ??? ?? ??????? ??????????? ??? ?????? ?????? ?????? ??????? ??????? ???? ?? ??? SQL Server ??????????? ????? ???????? ?? ????? ?? ??? ??? ???? ??:
  • SQL ????? ??????????? ????? ??????????? ??? ?? ??????????? ?????? ?? ????? ?? ??? ?? SQL ????? AlwaysOn ???????? ???? ?? SQL ????? ??????? ?????? ?????? ??????? ??? ?? ??????? ????? ???
  • SQL ????? ??????????? ????? ???????? ???? ???? ??????????? ?????? ??????? ??? ??? ?? ??????? ????? ??? ?? ???? ???? ?????? ??? ???? ??? ?? ??????? ??? ?? ?????? ????? ???? ???

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

??????? ???????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
??????? ?????? ???????? ?? ???????? ?? ???, ?????? ??? ??????, ???????? ?? ????, ?? ???????? ??? ?? ??? ????? ????COMPUTER_NAME> _ System_Information.txt
????????????? ??????? ?? ???COMPUTER_NAME> _ DiscoveryReport.xml
???????? ?? ????? ?? ?????? (Windows Server 2008 R2 ?? ??? ?? ?????????) ??????? ??? ?? ???????? ?? ????COMPUTER_NAME> _ ResultReport.xml


Systemlog

??? SQL ????? ??????????? ????? ??????????? ??????? ?? ????? 15 ????? ?? ??????? ???? ???

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
TXT, CSV, ?? EVT ?? EVTX ?????? ??? SystemlogCOMPUTER_NAME> _ evt_System.csv
COMPUTER_NAME> _ evt_System.txt
COMPUTER_NAME> _ evt_System.evt ??
COMPUTER_NAME> _ evt_System.evtx

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

???
SQL Server ??????????? ????? ??????????? ??????? ?? ????? 15 ????? ?? ????? ???? ???

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
TXT, CSV, ?? EVT ?? EVTX ?????? ??? ????????? ???COMPUTER_NAME> _ evt_Application.csv
COMPUTER_NAME> _ evt_Application.txt
COMPUTER_NAME> _ evt_Application.evt ??
COMPUTER_NAME> _ evt_Application.evtx


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

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
??????? ?????????? ?? ?????? ??? ?????????? ?? ?????? ??????? ?? ?? ???? ??? ????????? TXT XML ?????? ??? ?????? ???????? ??COMPUTER_NAME> _ EnvironmentVariables.xml
COMPUTER_NAME> _ EnvironmentVariables.txt


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

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
?????? ???????? ?? ??????? ?????? ?? ???? ??? ???????COMPUTER_NAME> _SC_Services_Output.xml


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

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
?? ????? ???? ??? Fltrfind.exe ?? ???? ?? ????? ??????? ??????? ?? ???? COMPUTER_NAME> _FltrFind.txt

????-??????? ??????? ?? ???????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
Fltmc.exe ?? ????? ???? ??? ???-??????? ??????? ?? ????COMPUTER_NAME> _Fltmc.txt

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

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
?? ??? ?????????COMPUTER_NAME> _sym_RunningDrivers.csv
?? ??? ?????????COMPUTER_NAME> _sym_RunningDrivers.txt
%windir%\system32\drivers\*.*COMPUTER_NAME> _sym_Drivers.csv
%windir%\system32\drivers\*.*COMPUTER_NAME> _sym_Drivers.txt
?? ??? ???????????COMPUTER_NAME> _sym_Process.csv
?? ??? ???????????COMPUTER_NAME> _sym_Process.txt


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


?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
??? SMB ???????????? ??????? ?????? ???? ???? ???, ??? ????, ??? ?? ????? ????, ??? ??????? net ???????? ???? net.exe subcommands ??COMPUTER_NAME> _SMB-Info.txt
??? tcp/ip ?? ?????????? ???????????? ??????? ???? tcp/ip ????????? ????? ?? ??????, ipconfig, netstat, nbtstat?? netsh ???? ??COMPUTER_NAME> _TcpIp-Info.txt
DNS ??????? ??????? ?????COMPUTER_NAME> _DnsClient_HostsFile.txt
???? ?????? IPCONFIG/DISPLAYDNSCOMPUTER_NAME> _DnsClient_ipconfig-displaydns.txt
DNSCLIENT ?? ????? NETSH ??????? ??????

??? ?? ???? Windows Server 2003 ?? ????? ???? ??
COMPUTER_NAME> _DnsClient_netsh_dnsclient-??-?????? ???TXT
DNS ??????? ????????? ????????????COMPUTER_NAME> _DnsClient_reg_.txt
Tcp/ip ???????? ????????? ????? HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

COMPUTER_NAME> _TcpIp_Parameters_Registry.xml
??????? ??????? ???COMPUTER_NAME> _NetworkAdapterConfigurations.xml



????????? ????? ?? ??? ??????? CurrentControlSet, ?? SQL ????? ????????? ?????? ?? ???? ????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
HKLM\System\CurrentControlSet\SessionManagersCOMPUTER_NAME> _CurrentControlSet_Reg.txt
HKLM\SYSTEM\CurrentControlSet\Control\LsaCOMPUTER_NAME> _CurrentControlSet_Reg.txt
HKLM\SYSTEM\CurrentControlSetCOMPUTER_NAME> _CurrentControlSet_Reg.hiv
SQL ????? HKLM\SOFTWARE\Microsoft\MicrosoftCOMPUTER_NAME> _REG_SQL.txt
HKLM\SOFTWARE\Microsoft\MSSQLServerCOMPUTER_NAME> _REG_SQL.txt
SQL ????? 2005 Redist HKLM\SOFTWARE\Microsoft\MicrosoftCOMPUTER_NAME> _REG_SQL.txt
HKLM\Software\Microsoft\MSFTESQLInstMapCOMPUTER_NAME> _REG_SQL.txt
SQL ????? ??????? HKLM\SOFTWARE\Microsoft\MicrosoftCOMPUTER_NAME> _REG_SQL.txt
HKLM\SOFTWARE\Microsoft\OLAP ?????COMPUTER_NAME> _REG_SQL.txt
HKLM\SOFTWARE\Microsoft\SNACCOMPUTER_NAME> _REG_SQL.txt
HKLM\SOFTWARE\Microsoft\SQLXML4COMPUTER_NAME> _REG_SQL.txt
HKLM\Software\Microsoft\VsaCOMPUTER_NAME> _REG_SQL.txt
HKLM\SOFTWARE\ODBCCOMPUTER_NAME> _REG_SQL.txt
HKLM\SOFTWARE\Microsoft\MSDTSCOMPUTER_NAME> _REG_SQL.txt
HKLM\SOFTWARE\Microsoft\MSXML 6.0 ?????? ?? SDK<COMPUTER_NAME>_REG_SQL.txt</COMPUTER_NAME>
HKLM\SOFTWARE\Microsoft\MSXML60COMPUTER_NAME> _REG_SQL.txt
SQL ????? HKCU\Software\Microsoft\MicrosoftCOMPUTER_NAME> _REG_SQL.txt
SQL ????? HKLM\SOFTWARE\Microsoft\MicrosoftCOMPUTER_NAME> _REG_SQL.txt
SQL ????? HKLM\SOFTWARE\Wow6432Node\Microsoft\MicrosoftCOMPUTER_NAME> _Wow6432Node_REG_SQL.txt
HKLM\SOFTWARE\Wow6432Node\Microsoft\MSSQLServerCOMPUTER_NAME> _Wow6432Node_REG_SQL.txt
SQL ????? 2005 Redist HKLM\SOFTWARE\Wow6432Node\Microsoft\MicrosoftCOMPUTER_NAME> _Wow6432Node_REG_SQL.txt
SQL ????? ??????? HKLM\SOFTWARE\Wow6432Node\Microsoft\MicrosoftCOMPUTER_NAME> _Wow6432Node_REG_SQL.txt
HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL ??? ??????? 10.0COMPUTER_NAME> _Wow6432Node_REG_SQL.txt
HKLM\SOFTWARE\Wow6432Node\Microsoft\SNACCOMPUTER_NAME> _Wow6432Node_REG_SQL.txt
HKLM\SOFTWARE\Wow6432Node\Microsoft\SQLXML4COMPUTER_NAME> _Wow6432Node_REG_SQL.txt
HKLM\Software\Wow6432Node\Microsoft\VsaCOMPUTER_NAME> _Wow6432Node_REG_SQL.txt
HKLM\SOFTWARE\Wow6432Node\ODBCCOMPUTER_NAME> _Wow6432Node_REG_SQL.txt
HKLM\SOFTWARE\Wow6432Node\Microsoft\MSDTSCOMPUTER_NAME> _Wow6432Node_REG_SQL.txt
HIV ?????? ??? HKLM\SOFTWARE\Microsoft\Microsoft SQL ????? ????? ?? ?????COMPUTER_NAME> _Microsoft_SQL_Server.hiv



PSTAT ?????? ?? ??????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
PSTAT ?? ???????EXECOMPUTER_NAME> _PStat.txt



Windows ???????? ???????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
??????? ???????? ?? ??? ?????? netsh advfirewall???? ?? ??????COMPUTER_NAME> _Firewall_netsh_advfirewall.txt
?????? ?? netsh advfirewall consec ???? ?? ??? ?????? ??? =COMPUTER_NAME> _Firewall_netsh_advfirewall-consec-rules.txt
Netsh advfirewall ??????? ?? ??????COMPUTER_NAME> _Firewall_netsh_advfirewall-export.wfw
?????? ?? netsh advfirewall ???????? ???? ??? ?????? ??? =COMPUTER_NAME> ????????-_Firewall_netsh_advfirewall-rules.txt
Netsh wfp ?????? netevents ?? ??????COMPUTER_NAME> _Firewall_netsh_wfp-??-netevents.txt
HKLM\SOFTWARE\Policies\Microsoft\WindowsFirewallCOMPUTER_NAME> _Firewall_reg_.txt
HKLM\SYSTEM\CurrentControlSet\Services\BFE COMPUTER_NAME> _Firewall_reg_.txt
HKLM\SYSTEM\CurrentControlSet\Services\IKEEXTCOMPUTER_NAME> _Firewall_reg_.txt
HKLM\SYSTEM\CurrentControlSet\Services\MpsSvcCOMPUTER_NAME> _Firewall_reg_.txt
HKLM\SYSTEM\CurrentControlSet\Services\SharedAccess"COMPUTER_NAME> _Firewall_reg_.txt


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

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
??????? ?????????? ?????? ?????????COMPUTER_NAME> _UserRights.txt


?? ???? ?? ??? ?????? ???????? ????? ??? ?? ????? ?? ???? ??? ???????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
?? ???? ?? ??? ?????? ???????? ????? ??? ?? ????? ?? ???? ??? ??????? COMPUTER_NAME> _DSMisc.txt


???????? ???? ?? TGT

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
???????? ???? ?? TGTCOMPUTER_NAME> _ Kerberos_klist.txt


?????? ???????? ?? Kerberos, LSA, ?? SChannel ????????? ????????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
HKLM:\System\CurrentControlSet\Control\Lsa
HKLM:\System\CurrentControlSet\Control\Lsa\MSV1_0
HKLM:\System\CurrentControlSet\Control\Lsa\Kerberos\Parameters
HKLM:\System\CurrentControlSet\Services\LanmanServer\Parameters
HKLM:\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL
COMPUTER_NAME> _ Authentication_Registry.xml


?????? ???????? ?? SQL ????? ?? ??? ???????? ?? ????? ??????? ????????????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
SQL ????? ??????? ???????????? (tcp/ip, NP, ???? ??????, ???????) ?? ??? ?????????? SQL ????? ?? ??? ??? ??? ??, (??????? ?????) ??????? ?????? ???????? ??? ?? ?? 64-??? ???????? ?? ????? 64 - ?? 32-??? ??????? ????? ????COMPUTER_NAME> _ SqlServer_Network_Configurations.xml


?????? ?????????? ?? ??? ?? SPNs ?? SQL ????? ???? ?? ?????? ???????? ?? ????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
?????? ?????????? ?? ??? ?? ?????? ???????? ?? SQL Server ?? SPNs ???? ????COMPUTER_NAME> _ SqlServiceAccounts_SPN_ADProperties.xml
COMPUTER_NAME> _ SQLInstances_Spn_Summary.xml


SQL ????? ?????? ???

SQL ????? ??????????? ????? ??????????? ???????? ????? ?????? ????? ?????? ?? ??? ???? ?? ??? 20 SQL ????? ?????? ??? ???????? ??????:
  • ???????? ?????? ??? ????? ?? ???? 200 MB ???? ?????? ?? ?? ???? ?? ???
  • ?????? ??? ????????? ???? ??? ???????? ?????? ??? ??????? ?? 250 MB ?? ???? ???? ?? ????? 250 MB ???? ?? ????? ??, ?? ??? ???????? ?????? ??? SQL ????? ?? ?????? ?? ??? ??????? ???? ????



?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
SQL ????? ?????? ??? ?? ??????? ????? ????????? ???? ?? ?? ???????? ?? ??????? ??? ?????????? ?? ??? ??????? ???? ??? ???????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _1033_ERRORLOG [.n]

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER_ERRORLOG [.n]

??? SQL ????? ??????????? ????? ??????????? Windows ?????? ??????? ?? ??????? ????????? ??, ?? ?? "??????" ?? "??????" ?????? ??????? ??? ?? ??? ?? ?? ???? ?????? ?? ???????? ?? ???? ???, ?? SQL ????? ?????? ??? ???? ??????? ???? ????

SQL ????? ????? ???

SQL ????? ??????????? ????? ??????????? ???????? ????? ?????? ????? ?????? ?? ??? ???? ?? ??? 20 SQL ????? ????? ??? ???????? ??????:
  • ???????? SQL Server ????? ??? ????? ?? ???? 200 MB ???? ?????? ?? ?? ???? ?? ???
  • ?????? ??? ????????? ???? ??? ???????? SQL Server ????? ??? ??????? ?? 250 MB ?? ???? ???? ?? ????? 250 MB ???? ?? ????? ??, ?? ??? ???????? SQL Server ????? ??? ??????? ?? SQL ????? ??????? ?? ??? ??????? ????


?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
SQL ????? ????? ??? ?? ??????? ????? ????????? ???? ?? ?? ???????? ?? ??????? ??? ?????????? ?? ??? ??????? ???? ??? ???????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _1033_SQLAGENT.[???? | ??]

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER__1033_SQLAGENT.[|N] ??

??? SQL ????? ??????????? ????? ??????????? Windows ?????? ??????? ?? ??????? ????????? ??, ?? ?? "??????" ?? "??????" ?????? ??????? ??? ?? ??? ?? ?? ???? ?????? ?? ???????? ?? ???? ???, ?? SQL ????? ????? ??? ???? ??????? ???? ????


???????? ????? SQL ?????

???????? ???? ?? SQL ????? ??????? ?? ??? SQL Server ??????????? ????? ??????????? 10 SQL Server ???????? ??????? ???????? ??????? ???????? ????? ?? ??????? ?????? ?? ?????? ???? ???? ??? ??????? ???????? ?? ?? ???? ???? ???? ?? ?? ?? ??? ?? ??? ????? ???? ??? ????? ???? ???????? ???? ??? ??? ???????? ??????? ????? ?????? ?? ????? ?????:
  • ???????? ???????? ????? ?? ???? 100 ???????? (MB) ???? ????? ?? ???? ?? ???
  • ???????? ???????? ????? 30 ????? ?????? ?? ?? ???? ??????
  • ?????? ??? ????????? ???? ?? ??? ???????? ???????? ??????? ???? ??? ?? SQL ????? ?? ??????? ?? ??? 200 MB ?? ???? ???? ?? ????? 200 MB ???? ?? ????? ??, ?? ??? ???????? ???????? ??????? SQL ????? ?? ?????? ?? ??? ??????? ???? ????


??? Zip ?????? ??? ???????? ???? ?? ???? ???? ??? ?? ?????? ?? ??? ??? ??????? ???????? ????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
???????? ????? SQL ????? ???????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _1033_SqlMiniDumps.zip

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER_1033_SqlMiniDumps. zip
??? ??? ??????? ????? ???? ??? ?? ?? ???????? ???? ?? SQL ????? ??????? ?? ??? ???????? ???? ??? ???????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _DumpInventory.log

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER_DumpInventory.log


???
?? ??????? ?? Windows ?????? ??????? ?? SQL Server ??????????? ????? ??????????? ????????? ??, SQL Server ???????? ??????? ??? ???? ??????? ??? ?? ?????? ??????? ??? ?? ??? "??????" ?? "??????" ???? ?????? ?? ???????? ????


SQLDIAG ???? ?????? ?????????

???? ?????? "????." ?? ?? ?? SQL ????? ?? ???????? ??????? ?? ??????? SQLDIAG ???? ?????? ????????? ????????? ?? ?? ????? ????????? ?????? ?? ????? ??? ?????????????? ???? ?? ?? diagnostic ?????? ???????? ???? ??? ???

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
SQLDIAG ????????? ?????????????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _1033_sp_sqldiag_Shutdown.out

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER_1033_sp_sqldiag_Shutdown.out

SQL ????? AlwaysOn ???????????? ???????

??? ???? ???????? SQL Server 2012 ?? SQL Server AlwaysOn ???????????? ??????? ???????? ?? ?? ???

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
SQL ????? AlwaysOn ???????????? ??????????????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _1033_AlwaysOn.out

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER_1033_AlwaysOn.out

?? ???? ?? ? ??? SQL Server AlwaysOn

?? ???? ?? ? ???? ??? SQL Server AlwaysOn ???????? ???????? ?? SQL Server ?????? ???????? ?? ??????? ?? ?? 2012 ?? ???????? ?? ?? ???? ??????? ???????? ?? ?? ??? ?? "???????? ?????? ?????????" ?????? ??? ?????????

???????? ????? ?????? ?? ??? ??????? ?? ????? ??? SQL Server AlwaysOn ?? ???? ?? ? ?? ?????? ?????? 20 ??? ?????? ???? ?? ???? ?? ????? ?? ??????? ??????, ??? ??????? ???????? ?? ?? ????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
?? ???? ?? ? ??? SQL Server AlwaysOn???????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _AlwaysOn_health_XeLogs.zip

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER_AlwaysOn_health_XeLogs.zip

???SQL ????? ??????????? ????? ??????????? Windows ?????? ??????? ?? ??????? ????????? ??, ?? ???? ?? "??????" ?? "??????" ?????? ??????? ??? ?? ??? ?? ?? ???? ?????? ?? ???????? ?? ???? ???, ?? SQL ????? AlwaysOn ????????? ??? ??????? ?????


SQL ????? ?????? ??????? ????????? ?????

SQL ????? ?? ???? ?? ? ??????? ??????? ??? ???????? "?????" ??????? ?? SQL Server ?????? ???????? ?? ??????? ?? ?? 2012 ?? ??????? ???? ???? ??????? ???????? ?? ?? ??? ?? "???????? ?????? ?????????" ?????? ??? ?????????

???????? ???????? ?? ??? ??????? ???? ????? ??????? ??????? ????????? ????? ?? ?????? ?????? 20 ??? ?????? ???? ?? ???? ?? ????? ?? ??????? ??????, ??? ??????? ???????? ?? ?? ????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
SQL ????? ?????? ??????? ????????? ????????????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _FailoverCluster_health_XeLogs.zip

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER_FailoverCluster_health_XeLogs.zip

??????? ?? "??????" ?? "??????" ?????? ??????? ??? ?? ??? ?? ?? ???? ?????? ?? ???????? ?? ???? ???, ?? SQL Server ?????? ??????? ????????? ??? ??????? ???? ????

SQL ????? ???????? ?????? ????????? ?????

SQL ????? ?? ???? ?? ? ???????? ?????? ??? ???????? ???????? ?? SQL Server ?????? ???????? ?? ??????? ?? ?? 2012 ?? ???????? ?? ?? ???? ??????? ???????? ?? ?? ??? ?? "???????? ?????? ?????????" ?????? ??? ?????????

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
?????????? ?? ???
SQL ????? ???????? ?????? ????????? ????????????? ???????:
COMPUTER_NAME>_INSTANCE_NAME> _system_health_XeLogs.zip

???????? ???????:
COMPUTER_NAME> _MSSQLSERVER_system_health_XeLogs.zip

??? SQL ????? ??????????? ????? ??????????? Windows ?????? ??????? ?? ??????? ????????? ??, ?? SQL Server ???????? ?????? ????????? ??? ??????? ???? ?? ???? ?? "??????" ?? "??????" ?????? ??????? ??? ?? ??? ?? ?? ???? ?????? ?? ???????? ?? ???? ????

???

???? ID: 2871695 - ????? ???????: 25 ??????? 2013 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Evaluation Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Parallel Data Warehouse
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Parallel Data Warehouse
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
??????: 
kbmt KB2871695 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2871695

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com