?????? ?????? ??? ??? ????? SQL Server 2005 ?????? ????? ?????? Service Pack 1 ??? ???? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 918695 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 433207 (SQLBUDT)
????? ???? | ?? ????

???????

??? ????? Microsoft SQL Server 2005 ?????? ????? ?????? Service Pack 1 (SP1) ??? ???? SQL Server 2005 ?? ????? ???? ??? ??? ????? ?????? ????? ???? ?????? SP1 ?????? ?? SQL Server 2005 ????? ????? ????????.

??? ??? ??? ??? ??????? SQL Server 2005 SP1 SQL9_Hotfix_KB913090_sqlrun_sql.msp.log ? ?????? ????? ??? ?????? ??????? ???????:
????? ????? 1
????? ???????: CommitSqlUpgrade
???? PerfTime: CommitSqlUpgrade: 10:41:04 ?????? 28 ????? ????
<Func ????? = 'ComponentUpgrade' >
???? ??? ????? ??????? ????? ????? ?? ??? ????? ??? ???? ???????:
???? ????? SQL Server ??????? ???????: [Microsoft] [SQL ?????? ????] [SQL Server] ?? ???? ?????? ??? ?????? 'dm_exec_query_resource_semaphores' ???? ??? ????? ?? ??? ???? ????? ????????? ????? ??????? ?? ?? ?????? "????? SQL Server" ??? ????.
<EndFunc ????? = 'ComponentUpgrade' Return = GetLastError '15151' = '0' >
????? PerfTime: CommitSqlUpgrade: 10:41:04 ?????? 28 ????? ????
????? ??????? darwin ?????? ?????.
<EndFunc ????? = 'LaunchFunction' Return = GetLastError '15151' = '0' >
MSI (s) (98:98) [10:41:05:637]: ????? ???? InstallExecuteSequence.
MSI (s) (98:98) [10:41:05:637]: ??????: 1: 2262 2: InstallExecuteSequence 3:-2147287038
MSI (s) (98:98) [10:41:05:637]: ????? ???? InstallExecuteSequence.
MSI (s) (98:98) [10:41:05:637]: ????? ???? InstallExecuteSequence.
MSI (s) (98:98) [10:41:05:637]: ??????: 1: 2262 2: InstallExecuteSequence 3:-2147287038
MSI (s) (98:98) [10:41:05:637]: ????? ???? InstallExecuteSequence.
MSI (s) (98:98) [10:41:05:637]: ??????: 1: 2262 2: InstallExecuteSequence 3:-2147287038
(s) MSI (98:98) [10:41:05:637]: ????? ???? InstallExecuteSequence.
MSI (s) (98:98) [10:41:05:637]: ??????: 1: 2262 2: InstallExecuteSequence 3:-2147287038
?????? ??????? 10:41:05: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. ????? ?????? 3. ?????? ??????? 10:41:05: ?????. ????? ?????? 3.
????? ????? 2
SqlUpgradeMessage ??????? (S): = ???? ????? SQL Server ??????? ???????: [Microsoft] [SQL ?????? ????] [SQL Server] ?? ???? ?????? ??? ?????? 'dm_exec_query_resource_semaphores' ???? ??? ????? ?? ??? ???? ????? ????????? ????? ??????? ?? ?? ?????? "????? SQL Server" ??? ????.
UpgradeInstruction ??????? (S): = ??????? ????? SQL ComputerName \ SQLInstanceName ?? ????? ??????
????? ??????? ??????? ????? SQL
????? ??? ???????? ????? C:\Program Server\MSSQL.2\MSSQL\Install\sysdbupg.sql SQL Files\Microsoft
????? ??? ???????? ????? Server\MSSQL.2\MSSQL\Install\DbEngine_hotfix_install.sql SQL Files\Microsoft C:\Program
??? ???????? ????? ??????? Server\MSSQL.2\MSSQL\Install\repl_hotfix_install.sql SQL Files\Microsoft C:\Program
????? ???? MSSQL $ INST2
MSI (s) (98:98) [10:41:07:137]: ??????: Microsoft SQL Server 2005 - ????? ' Service Pack 1 ?? SQL Server ????? ?????? ????? 2005 ENU (KB913090) ' ???? ?????. ??? ????? 1603. ????? ??????? ?????? ?? ????? ??? C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log.

(s) MSI (98:98) [10:41:07:137]: ??????: Microsoft SQL Server 2005--??? ???????.
?????? ?? ???? ??? ??????? ??? ????? ???? ?????? Service Pack 2 (SP2) SQL Server 2005.

?????

????? ??? ??????? ??? ??? ????? ???????? ???????? ??? ????? ?? ??? ?????? ??? ??? ????? ?????? ??????? ???? ?? SQL Server 2005 ????? SQL Server 2005 ?????? ????? ?????? SP1. ???? ?? ???? ?? ??? ????? ???????? ???????? ?? ????? ????? ???????. ??? ??? ????? ???????? ???????? ??? ?????? ?? ??????? ?? ???????? ? ??????? ????? ????? ?????? ?? ??? ??????. ??? ??? ??? ???? ????? ????? ???????? ???????? ????? ??? ??????? ??? ????? SQL Server 2005 ?????? ????? ?????? SP1. ???? ??? ??????? ????? ??? ?????? ??????? ? ????? ????? ?????? ??????? ??? ???????.

???? ??????

??????? ?????? ??? ??? ??????? ???? ?? ?? "" ???????? ? ????? ????? ?????? ??????? ???????? ?? ??? ?????? ?? ???? ??? ?? SQL Server 2005 ??? ????? ???? ?????? SP1 ?????? ????? SQL Server 2005.
????? ??????? ???? Sysinternals Process Explorer (Procexp.exe) ?????? ???? ???????? ???????? ??????? ????? ???????? ???? ??? ????????? ?????? ?????? ???? SQL Server 2005.

?????? ??? Process Explorer ?? ?????? ???? ????? Sysinternals ??????:
http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx
???? Microsoft ??????? ??? ??????? ?????? ????? ???? ???????? ?? ?????? ??? ????? ??????. ?? ??? ????? ??????? ??? ??????? ??? ???? ?????. ??? ???? Microsoft ??? ??? ????????? ???? ???????.

?????? ???? ???????? ? ????? ????? ?????? ??????? ?? Process Explorer ???? ??????? ???????:
  1. ?? "?????? ?????" ????? ???? ????? Sqlservr.exe ?? ?????? ???.
  2. ?? ??????? ???? ???? ??? ????? ????? ??????.
  3. ?? ????? ?????? ?? Process Explorer ???? ?? ??? ???? "?????".

    ??? ?? ??? ??? ???? "?????" ? ???? ??????? ???????:
    1. ?? ??????? ???? ???? ??? ????? ??????? ?? ???? ??? ?????? ???.
    2. ???? ?????? ???? ???????? ??? ?? ???? ??? ?????.
  4. ?? ????? ??????? Process Explorer ???? ??? ??? ???? ????? ??? ?????.
  5. ????? ??? ??? ????? ?? ?????? ??? ???? ??? Mssqlsystemresource.mdf ?????. ??? ?????? ?? ???? ??? ????? ?????? ???????. ????? ????? ????? ?????? ??? ???? ??? Master.mdf. ??? ?????? ?? ???? ??? ????? ???????? ????????.
??? ???? ??? ???????? ??????? ??? ???? ??? ????? ????? ???????? ??? ??? ??????.

????? ????? ?????? ??????? ??? ???? ????? ???????? ????????. ??? ??? ???? ????? ???????? ???????? ??? ???? ????? ??? ????? ?????? ??????? ??? ??? ?????? ??? ??? ????? ???????? ????????. ?? ??? ????? ?????? ??????? ?? ??????? ?? ???????? ?? ?????? ???? ??????? NTFS. ?? ???? ?????? ????? ???? ???? ???? ???? ??????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

??????? ????

??? ?????? ??? ???????? ??? ???? ?????? ?? ????? ????? ?????? ??????? ??? ????????? ??? ???? ????? ??? ???????. ?? ???? ??????? ?????? ?????? ??? Sysinternals FileMon (Filemon.exe) ??????? ????? SQL Server 2005 ?????? ????? ?????? SP1 ?????? ?????? ??????:
  • ?????? ??????? ?????? ????? ????? ?????? ??????? ?? ?????? ??? ???? ????? ???????? ????????. ???? ????????? ??????? ?? ?????? ??????? ??????? FileMon:
    ????? ???? C:\DATA\mssqlsystemresource1.mdf IRP_MJ_WRITE msiexec.exe:1944 10:39:49 ?: ??? 22572523: 24052
  • ????? Sqlservr.exe ????? ????? ???????? ???????? ?? ?????? ?????? ??? ????? ??????? ????? ???????. ???? ????????? ??????? ?? ?????? ??????? ??????? FileMon:
    sqlservr.exe:2788 10:40:56 ? IRP_MJ_READ ???? ????? ???? C:\DATA\master.mdf: ??? 1900544: 65536
  • ????? Sqlservr.exe ?????? ????? ?????? ??????? ?? ?????? ??????. ????? ??? ?????? ?????? ??? ??????? ?????? ?? ????? ????? ?????? ???????. ???? ????????? ??????? ?? ?????? ??????? ??????? FileMon:
    C:\Program IRP_MJ_READ ???? sqlservr.exe:2788 10:40:56 ? Server\MSSQL.2\MSSQL\DATA\mssqlsystemresource.mdf SQL Files\Microsoft ???? ?????: ??? 1245184: 65536
???? ??? ?????? ??? ????? ??? ????? ????? ?????? ??????? ????????? ????? ????? ?????? ??????? ???? ????? ?????? "???????" ????????? ??????.

?????? ??? FileMon ?? ?????? ???? ????? Sysinternals ??????:
http://technet.microsoft.com/en-us/sysinternals/bb896642.aspx
???? Microsoft ??????? ??? ??????? ?????? ????? ???? ???????? ?? ?????? ??? ????? ??????. ?? ??? ????? ??????? ??? ??????? ??? ???? ?????. ??? ???? Microsoft ??? ??? ????????? ???? ???????.

?????

?????? ??? ???? ?? ????????? ??? ????? ??? ?? ???????? ?????? ??????? ?? ?????? ???? ???? ????? Microsoft (MSDN) ?????? ??? ?????:
http://msdn2.microsoft.com/en-us/library/ms345408.aspx
?????? ??? ???? ?? ????????? ??? ????? ??? ????? ???? SQL Server 2005 ???????? Microsoft Windows ????? net ?? ?????? ???? MSDN ??????:
http://msdn2.microsoft.com/en-us/library/ms187598.aspx

???????

???? ???????: 918695 - ????? ??? ??????: 08/???/1428 - ??????: 1.6
????? ???
  • Microsoft SQL Server 2005 Service Pack 1
????? ??????: 
kbmt kbsql2005setup kbexpertiseadvanced kbtshoot kbprb KB918695 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????918695

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

 

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