SQL ????? 2005 ?? ??????? ?? SQL Server 2005 ?????? ??? 1 ??????? ???? ??? ?? ?????? ????? ?? ???? ??

???? ?????? ???? ??????
???? ID: 918695
Bug #: 433207 (SQLBUDT)
??? ?? ??????? ???? | ??? ?? ??????? ????

?????

?? ???? Microsoft SQL Server 2005 ?????? ??? 1 (SP1) ?? SQL Server 2005 ?? ?? ?????? ??????? ??, ?? ????? ?? ???? ?????? ?? SQL Server 2005 SP1 ????? ????????? ???????? ??????? ?????

??? ?? ??????? SQL Server 2005 SP1 SQL9_Hotfix_KB913090_sqlrun_sql.msp.log ??? ????? ?? ??????? ????? ???? resemble ????? ?????? ?????:
?????? ????? 1
?????? ?? ?? ??? ??: CommitSqlUpgrade
PerfTime ???????: CommitSqlUpgrade: ????? ?????? 28 10:41:04 2006
<func name="ComponentUpgrade"></func>
?? ?????? ??????? ??? ?? ????? ????? ??? ?? ????? ?? ??? ?? ??? ?????:
SQL ????? ????? ??? ????? ?????? ??? ??: [Microsoft] [SQL ??? ???????] [SQL Server] ???? ???? ???????? 'dm_exec_query_resource_semaphores', ??????? ?? ????? ???? ?? ?? ???? ?????? ???? ?? ???? ???? ?? ??? ?????? ?? ?? ????, ?? ???? ??? SQL Server ????? ?? ??? ?? ??????
<endfunc name="ComponentUpgrade" return="15151" getlasterror="0"></endfunc>
PerfTime ?????: CommitSqlUpgrade: ????? ?????? 28 10:41:04 2006
?????? ???????? ?? ??? darwin ????? ?? ??????? ?????
<endfunc name="LaunchFunction" return="15151" getlasterror="0"></endfunc>
MSI (s) (98:98) [10:41:05:637]: ?????? InstallExecuteSequence Transforming.
MSI (s) (98:98) [10:41:05:637]: ???: 1: 2262 2: 3:-2147287038 InstallExecuteSequence
MSI (s) (98:98) [10:41:05:637]: ?????? InstallExecuteSequence Transforming.
MSI (s) (98:98) [10:41:05:637]: ?????? InstallExecuteSequence Transforming.
MSI (s) (98:98) [10:41:05:637]: ???: 1: 2262 2: 3:-2147287038 InstallExecuteSequence
MSI (s) (98:98) [10:41:05:637]: ?????? InstallExecuteSequence Transforming.
MSI (s) (98:98) [10:41:05:637]: ???: 1: 2262 2: 3:-2147287038 InstallExecuteSequence
MSI (s) (98:98) [10:41:05:637]: ?????? InstallExecuteSequence Transforming.
MSI (s) (98:98) [10:41:05:637]: ???: 1: 2262 2: 3:-2147287038 InstallExecuteSequence
?????? 10:41:05 ?????? ?? ?? ??: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. 3 ??? ???? ??? ??? ?????? ?? 10:41:05 ???: ??????? ????? 3 ??? ???? ??? ???
?????? ????? 2
??? (S): SqlUpgradeMessage = SQL Server ????? ??? ????? ?????? ??? ??: [Microsoft] [SQL ??? ???????] [SQL Server] ???? ???? ???????? 'dm_exec_query_resource_semaphores', ??????? ?? ????? ???? ?? ?? ???? ?????? ???? ?? ???? ???? ?? ??? ?????? ?? ?? ????, ?? ???? ??? SQL Server ????? ?? ??? ?? ??????
??? (S): UpgradeInstruction SQL ??????? ?? ?????? ???? =ComputerName\SQLInstanceNamesysadmin ?? ??? ???
SQL ??? USE ?????? ????? ????
????????? ????? C:\Program ????? Files\Microsoft SQL Server\MSSQL.2\MSSQL\Install\sysdbupg.sql
????????? ????? C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Install\DbEngine_hotfix_install.sql ????? ????
????? ????????? ????? C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Install\repl_hotfix_install.sql
???? ?? ????? MSSQL $ INST2
MSI (s) (98:98) [10:41:07:137]: ??????: Microsoft SQL Server 2005 - ?????? ' SQL Server ??????? ?????? 2005 ENU ?? ??? ?????? ??? 1 (KB913090) ' ??????? ???? ???? ?? ???? ?????? ??? 1603? ???????? ??????? ??? ??? ?????? ?? C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log ????? ???

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

????

?? ?????? ?? ???? ?? ???????????????????? ???? ?? ??? ??? ?? ?? ????? ?? ???? ????????SQL ????? 2005 ??? ?? ?? SQL Server 2005 SP1 ?? ??????? ???? ?? ?????? ?? ??? ??????? ?????? ???? ??? ???? ?? ????????????????? ?? ???? ??? ??? ?? ??????? ????? ??? ?? ?? ?? ????????????????? ?? ???, ???? ?????? ????????? ???? ?? ????????, ??????????????? ????? ?? ??? ??????? ??? ????? ???? ??? ?? ???? ??????????????? ???????, ?? ?? ?????? ?? ????? SQL Server 2005 SP1 ?? ??????? ???? ??? ?? ?????? ?? ???? ?? ??????? ?? ???????????, ??????????????? ??????? ????? ???

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

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

????????? Explorer ?? ??????? ???? ?? ??? ????? Sysinternals ??? ???? ?? ????:
HTTP://TechNet.Microsoft.com/en-us/sysinternals/bb896653.aspx
?????? ?????? ???? ??? ???? ?????? ???? ?? ??? Microsoft ???? ?????-???? ?????? ??????? ?????? ????? ??.. ?? ?????? ??????? ???? ???? ????? ????? ?? ??? ???? ??.. Microsoft ?? ?????-???? ?????? ??????? ?? ??? ???? ?? ??? ?????? ???? ????..

????? ?? ??? ????? ?? ?????????, ????????????????? Explorer ??? ??????? ?? ??????? ?? ???, ????? ????? ?? ???? ????:
  1. ????????? Explorer ???, ??????Sqlservr.exe??? ????????????????????
  2. ????? ????????????? ??,????? ??? ??????.
  3. ????????? Explorer ?? ????? ???, ????????? ???? ?? ?????????? ????????? ???? ???? ???

    ??? ????? ??? ????????? ???? ???? ???? ??, ?? ????? ????? ?? ???? ????:
    1. ????? ????????????? ??,??????? ?? ??? ????????? ????, ?? ???? ????????????
    2. ?? ??? ???? ?? ??? ????? ??????????????? ?? ????? ?? ??? ????? ????, ?? ???? ???OK.
  4. ????????? Explorer ?? ????? ???, ????? ??????????:????? ?? ?????? ?? ????? ?????
  5. ?? ???????type items, search the???column for the path of the file Mssqlsystemresource.mdf file. This path is the path of the??????database file. You can also search the???column for the path of the Master.mdf file. This path is the path of the??????database file.
If these paths are different, you must move the database files to the same folder.

The??????database depends on the location of the?????????????:. ??? ?? ?? ??????????database, you must also move the??????database to the same location as the??????database file. Do not put the??????database in either compressed or encrypted NTFS file system folders. If you do this, you hinder performance and prevent upgrades.

??????

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

???? ???????

??? ?? ?? ?????? ?? ????? ???? ???, ?? ???? ???? ?? ?? ????????????????????????? ????? ?? ???????? ?? ?? ?? ?????? ?? experiences ???????? ???????? ?? ???? ??? SQL Server 2005 SP1 ?? ??????? ?? ??????? ???? ?? ??? ???? ??? ?????? ???? Sysinternals FileMon (Filemon.exe) ?? ????? ????, ?? ????? ??????? ????? ????:
  • ????? ????????? ??????????????????? ??? ??????? ?? ??????? ????????????????? ????? ??? ????? ??????? FileMon ?? ????? ????? ??? ????? ???? ??:
    10:39:49 AM msiexec.exe:1944 IRP_MJ_WRITE C:\DATA\mssqlsystemresource1.mdf ????? ?????: 22572523 ?????: 24052
  • Sqlservr.exe ????????? ?? ??? ???? ??????????????? ?? ?? ????? ?? ????????? ????? ?? ????? ??????? ???? ??? ????? ??????? FileMon ?? ????? ????? ??? ????? ???? ??:
    10:40:56 AM sqlservr.exe:2788 IRP_MJ_READ C:\DATA\master.mdf ????? ?????: 1900544 ?????: 65536
  • Sqlservr.exe ????????? ?? ??? ???? ??????????? ????? ?? ???????? ?? ??? ????? ?? ?????? ??????? ??? ????? ????????????????? ???????? ????? ??????? FileMon ?? ????? ????? ??? ????? ???? ??:
    10:40:56 AM sqlservr.exe:2788 IRP_MJ_READ C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mssqlsystemresource.mdf ????? ?????: 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
Microsoft Windows ?? ????? ???? SQL Server 2005 ?? ?? ???????? ?? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ???NET????, ?? ????? MSDN ??? ???? ?? ????:
HTTP://msdn2.Microsoft.com/en-us/library/ms187598.aspx

???

???? ID: 918695 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
??????: 
kbsql2005setup kbexpertiseadvanced kbtshoot kbprb kbmt KB918695 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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