?? ???? ??? ????? ????? 823 ????? ??????? ?? ????? ?????? ?? ???? SQL

?????? ????????? ?????? ?????????
???? ???????: 828339 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

?? ???? ???? ????? ????? ??????? ??? ?? ???? ??? ?? Microsoft SQL Server 2000 ??? ????? ??????? ?? ?????? ????? ?? ??????? ?? ?? ??????? ??? ????? ????? ????????:
??? 823
??? ?????/????? <error > ???????? ????? <operation > ??? ??????? <offset > ?? ??? ' <file>'
?????? ????? ????? ????? ?????? ?????? ?? Microsoft SQL Server 2005 ? Microsoft SQL Server 7.0. ??? ???? ??? ???????? ?????????? ????? ????? SQL Server 2005 ? SQL Server 7.0.

?????? ??? ???? ?? ????????? ??? ????? ?????? ?? ??? ??????? ??? <error > ? <operation > ? ? ?????? ??? ???? ?? ????????? ??? ????????? ??????? API Windows Microsoft ???? ??? ?????? SQL Server 2000 ???? ????? "???? ?? ?????????" ?? ??? ???????.

????

??? SQL Server 2000 ????? ???????? ?? ??? "???????" ?? ??? ??????? ??? ????? ???????? ?????????:
  • ??? ?? ???? ???????: ????? A ??????? Windows API ?? ????? ??????? Windows API ??? ??????? ? SQL Server ???? ??? ???? ??????? ???????? ??? ??????? Windows API. ????? ????? ??????? ???? ?? ??? ??? ????? ???????:
    ??? spid75 09:01:27.38 28 ????? 2003: ??????? ??? ?: ? 24
    ??????: 2
    ????? 28 ????? 2003 09:01:27.38 spid75 I/O 1117 (????? ???? ????? ????? I/O ???? ?????.) ?? ??? ????? ????? ??? ??????? 0x0000002d460000 ?? ??? 'files\Microsoft e:\program Server\mssql\data\mydb.MDF SQL'
    ???????? ?? ????? ??? ???? ??????? 6 (? ?????? ??? ???? ?) ? ???????? ????? ???? ??????? ??? ??????? ???? ?? ????? ??? ?? ??????? ?? ???? ??????? ?????? ???????? ?? ????? ?? ??????. ?? ???? ???? ???? ???? ??????? ??? ?? ???? ????? CHECKDB DBCC ????? ????? ??????, ?? ????? ??? ????? ?? ????? ?? ???? ??????? ?? ????? ?????? ?? ????? ??? ?????? Microsoft ??? ??? ???????.

    ?????? ?? ?? ???? ??? ????? ????? ?? ??????? CHECKDB DBCC ??? ????? ???????? ???? ?? ??????? ?? ????? ?? ????? ?????. ????? ????? ??????? CHECKDB DBCC ??? ???? ??? ???. ??? ??? CHECKDB DBCC ????? ????? ????? ?? ????? ? ?? ??????? ?? ???? ???? ????? ?? ???? ?????? ?? ????? ?? ???.
  • ??? ???????? ???????? I/O: ??? ??? ??? ??????? Windows API ????? ?? ????? ??????? Windows API ???? ????? ?????? ????? ?????? ??????? ????? ??? ???????? ??? ??????? (torn ???? ??? ??? ???? ??????) ? ???? ??? ???. ????? ????? ??????? ???? ?? ??? ??? ???????/????? ?????? ???? ?????:
    ??? spid17 16:51:18.90 2003 09 05: ??????? ??? ?: ? 24
    ??????: 2
    ? ?????? 2003 16:51:18.90 I/O spid17 ????? ?? ????? ??????? ?? ??? (?????? torn) ????? 0x00000094004000 ?? ????? 'F:\SQLData\mydb.MDF'
    ??? ??? ??????? ????? ????? ??????? CHECKDB DBCC ??? ????? ???????? ???? ?? ??????? ?? ????? ?? ????? ?????. ??? ????? CHECKDB DBCC ????? ????? ??? ??????? ??? ??????? ??? ???????. ??? ?????? ??????? ??? ??? ????? ????? CHECKDB DBCC ?? ?? ???? ??? ????? ????? CHECKDB DBCC ??? ????? ?????? ??? ????? ???? Microsoft Windows NT ?????? ??? ??? ????? ?????? ?? ????? ???????? ??????. ????? ????? ??????? ????? ??????? ????? ?? ?????? ??????? ????????.

??????? ????

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

??? ??? ????? ????? ????? ??? ??????? ????????:
??? 823
??? ?????/????? <error > ???????? ????? <operation > ??? ??????? <offset > ?? ??? ' <file>'
???? ?? ???? ??? ??????? ????? ????? ??? ????????:
  • <error >: ???? ?? ???? ??? ??? ???? ??????? ?? ??? ???????? I/O ??????. ??? ?? ???? ??????? ??? ??? ???? ??????? ???? ? ??? I/O ?. ??? ????? ???? ??? ???? ??????? ?? ????? ??? ??? ?????/?????"error number. "

    ?????? ??? ??? ???????? I/O ?????? ? ????? ??? ???? ??????? ????? ???? ?? ???? ???? ??? ???:
    • (???? torn): ????? ?? ????????? ??? ??????? torn ???? SQL Server 2000 ????????.
    • (????? ?????? ??? ?????): ??? ??????? ???? ?? pageID ??? ??? ???? ??? ?????? ??????? ???? ??? ??????? ?? ?????. ??? ???? ??????? ??? ???? SQL Server 2000 ??? ????? ??? ????? ???????? 1 ?? ??? ?????? ???????? 100 ? ??? ?? ???? pageID ??? ??? ???? ???? ?????? ???????? 8 1:100. ??? ????? ??? ?? ????? ?????? ???? ?? ????? ??? ???????? I/O ????????.
    • (??? ???? ??? ?????): ??? ??????? ???? ??? ???? ????? ??????? Windows API ???? ?? ????? ?????? ???? ?? ????? ?? ?? ??? ?? ???????.
  • <operation>: ?? ??????? ?? ???????.
  • <offset>: ??? ?? ????? ?????? ??????? ?? ????? ?????. ???? ??? ????? 8192 ????? ??? ?????? ???????? ????? ?????.
  • <file>: ??? ?? ????? ???? ????? ??????? I/O ?????? ?????? ?????? ?????? ????? ??.

SQL Server API I/O ? Windows

?????? SQL Server 2000 ????????? API Windows ???????? ??? ReadFile ? ReadFileScatter WriteFile ? WriteFileGather ? ?????? I/O ?? ????? ????? ???????? ?????? ??. ????? ?????? SQL Server 2000 ????????? API Windows, ????? ?? ?????? ??? ????? ?? SQL Server 2000 ??? ?????? ??????? ???? ?? ??????? ????. ?????? ??? ?? ???? ??????? API Windows ???? ??? ????? ?? ??? ??? ??? ????? ???? ??????? 6 ("??? ???? ??????") ????? ??????? ?? ??? ????? ?? Windows ?? ?????? ??? ?????? ????? ??? ????? ??? ??? ?????? ????? ????. ???? ??? ???? ??????? 6 ?????? ??? ????, ?? ???? ??? ??????? ??? ??? SQL Server ?????? ????? ??? ???? ??? ????? ??????? Windows API. ??? ???? ?? ?? ???? ???? ??? ????? ?? ????.

??? ???? ??????? ??? ?????? ????? ????? ??????? ?? ??? SQL Server Errorlog SQL Server ???? ??? ???? ??????? 2 ????? ?????? ??????? API Windows ??????? ??? ??? ????? ???????? ???????? tempdb:
823 ???: ???????: ???? 24 ?: 4
??? ?????/????? 2 (????? ??? ?????? ?????? ??? ????? ??????.) ????? ?? ????? ??????? ??? ??????? 0x00000000284000 ?? ??? ' D:\Program Server\MSSQL\data\tempdb.mdf SQL Files\Microsoft '
??? SQL Server ?? ??? ????? ?????? ????? ?? ????? ??? ? "??????"??? ???? ? ????? ??????? ?? ??? ????? ?? ??? ?????? ????? kernel ??????? ?????? ??? ???? ??????? ?? ?????? ????? ????. ?? ???? ??? ??????? ??? ????? ?? SQL Server ? ??? ?? ??? ?????? ?? ???? ????? ???? ?? ???? ??????? ?? ?????? ????? ???? ??????? ??????.

?????

?? ??? ????? ??????? ??????? ?????? ????? ??? ??? ??? SQL Server Errorlog ??? ??????? ????? ???? 818. ?????? ??? ??????? ?????? ??? ??? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
826433PRB: ????? ????? ?? ????? I/O unreported ????? ?????? SQL Server
????? ???? SQL ????? ???? ? ???? ??????? ??? ????? ?????????? ? ??? ?? ???? ?? ??? ?????? Microsoft SQL Server Always-On ??????? ???? ??????. ??????????? ?? ????????? ??? ??????? ??????? ???? ????? ?????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
967576??????? ???????/??????? ???? ????? ?????? ???? Microsoft SQL

???????

???? ???????: 828339 - ????? ??? ??????: 18/?? ??????/1426 - ??????: 2.4
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt kbprb KB828339 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????828339

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

 

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