????? ?????? ??? ??? ????? suspect ???? ?????? ?????

???? ???????: 180500 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

???????

?????? SQL Server suspect ????? ?????? ??? ??? ?? ?? ????? ??????? ?????? ???????? ??? ?????? ????? ????? ???. ?? ??? ?? ?? ??????? ????? ?? ??? ????? SQL Server ???????:
????? ????? 1
udopen kernel 10:48:32.60 11 96 18: ???? ??????? ??? 32 (
????? ??? ??????? ?????? ??? ????? ???? ??? ????????? ?? ??? ???
??? ???????.) ????? ?????/??????? ?????? ??????
C:\DATA\SQL\MSDB.DAT (?? C:\DATA\SQL\MSDB.MDF)

11 96 18 10:48:32.60 kernel udactivate (?????): ??? ?? ???
?????? C:\MSSQL\DATA\MSDB.DAT (?? C:\DATA\SQL\MSDB.MDF) vdn 127
????? ????? 2
udopen kernel 10:48:32.60 11 96 18: ??? ???? ??????? (2
????? ??? ?????? ?????? ??? ????? ??????.) ????? ???????/???
??????? ?????? C:\MSSQL\DATA\MSDB.DAT (?? C:\DATA\SQL\MSDB.MDF)

11 96 18 10:48:32.60 kernel udactivate (?????): ??? ?? ??? ?????? C:\MSSQL\DATA\MSDB.DAT (?? C:\DATA\SQL\MSDB.MDF) ?? vdn 127
??? ?? ???? ??? ???? ??? ?? ????? ?? ????:
udread kernel 10:48:36.70 11 96 18: ??? 6 (?? ???? ???????
???? ??? ????.) ??? ?????? 'C:\MSSQL\DATA\MSDB.DAT' (?? C:\DATA\SQL\MSDB.MDF) (virtpage
0x7f000018).

??? spid11 10:48:36.77 11 96 18: ??? ? ???????: ???? 17 ?: 2

11 96 18 10:48:36.77 ??????? spid11 'MSDBData' (?? ????? ??????
'C:\MSSQL\DATA\MSDB.DAT' (?? C:\DATA\SQL\MSDB.MDF) ? ???? ???? ????? 127) ???
?????. ?????? ???? "?????? ??????" ?????? ??? ????????.

11 96 18 10:48:36.77 1092480 ???? spid11 ?? ????? ???????? 'msdb'
????? ??? ?????? 0 ?? ??? ?????? ??? ?????? 24 ??
??? ?????? ??????

11 96 18 10:48:37.43 ???? spid11 ??????? ????????? ??
dbid <5>????? ????? ???????. ?????? ??????
????? ????????.
??? ???? ??????? ?????? ???????? ??????? ???? ??? ???????:
  1. ????? ???? SQL.
  2. ?????? ????? ?????? ?? ???? ??????? ?? Mssql\Data ??????:

    ren msdb.dat msdb.sav
  3. ??? ????? ???? SQL.
??? ??? ??????? ????? (??? ?? ???????? ???????) ?? errorlog SQL Server. ??? ?? ????????? ?????? ?? ????? ???????? ???????? 
   select name, dbid, mode, status from sysdatabases where dbid =
   db_id('msdb')

???? ??????? ???????: 
   name     dbid   mode   status
   ------------------------------
   msdb      5      0      328

????? ?????? 328 ???: 
   truncate log on chkpt
   database not recovered yet
   database is suspect

????? ?? ?????????? ???? ??????? "Sysdatabases (????? ?????? ???????? ???)" ?? "??? SQL Server ???????".
???? ??? ?????? | ????? ???????

?????

??? ??? ???????? ??????? SQL Server ?????? ??? ????? ????????? ??? ??? ??? ??????. ?????? ??? ????????? ?????? ????? ???? (??? ???? ??????? ?????? ????? ?????????) ?? ??? ????? ??????? ???? ???? ????????? ??????? ?????. ?? ??? ???????? ?? ???? ????? ??? ??? ???? ?? ????? ???????? ??????. ????? ???????? ???????? ???? ????? ??? ??? ?????? ?????? ??? ??? ????? ????? ???? ????? ????????.
???? ??? ?????? | ????? ???????

???? ??????

??????? ?????? ??? ??? ??????? ?? ?????? ??????? ?????. ???? ?? ?????? ??????? ??????.
  1. ???? ?? ???? ?????? ????? ???????.
  2. ??????? sp_resetstatus ??????? ?????? ???????? ?????? ????? ???? ????? ???????? ????? ???. ??? ?? ??? ?? ??? ?????? ?????? ??? ? ????? ??? ??????? ?????? ????? ???????? ????? Instsupl.sql ????? ?? ?????? Mssql\Install. ?????? ??? ???? ?? ????????? ??? sp_resetstatus ???? ??????? "??????? ?? ??? ?? ??????" ?? "??? SQL Server ???????".
  3. ????? sp_resetstatus ?? ????? ???????? ???????? ?????? ???????? ????? ???: 
          use master
      go
      exec sp_resetstatus msdb   -- replace msdb with your database name
    ???? ??? ???? ??????? ??????: 
          Prior to Update sysdatabases attempt for DBName='msdb', the mode=0
      and status=328 (status suspect_bit=256). For DBName='msdb' in
      sysdatabases, status bit 256 was forced Off and mode was forced to
      0. WARNING: You MUST stop/restart SQL Server prior to accessing this
      database!
  4. ????? ?????? ????? SQL Server.
  5. ???? ?? ????? ???????? ?? ??????? ??????.
  6. ????? NEWALLOC DBCC ? TEXTALL DBCC CHECKDB DBCC.
???? ??? ?????? | ????? ???????

??????? ????

??? ?? ??? ????? ???????? ?? ???? ??? suspect ??? ????? ??????? ??????? ? ?? ???? ???? ????? ???? ???? ??????? ????? ????????. ??? ??? ??????? ????? ??? ??????? ?? ???? ???????? ???? ?? ????? ????? ???????? ??? ????? ??????? ???????? ?????? ?????? ????? ????? (BCP) ??? ???? ???????? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
165918
(http://support.microsoft.com/kb/165918/ )
????? ??? (???????) ? ????? ???????? WITH NO_LOG
??? ??? ??? ???????? ??? ??????? (Q165918) ??? ????? ?? ????? ?????? ?? ?? ????????? ???? ???? ?????? ???? ????? ????? ??????? ?????? ??? ????????.

???? ??? ?????? | ????? ???????

???????

???? ???????: 180500 - ????? ??? ??????: 03/????? ??????/1427 - ??????: 5.0
????? ???
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbmt kbprb KB180500 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????180500
(http://support.microsoft.com/kb/180500/en-us/ )
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????
???? ??? ?????? | ????? ???????

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

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