INF: ?????? ?????? ?????? ????? ???? SQL Server ?? ?????????

?????? ????????? ?????? ?????????
???? ???????: 124023 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ??? ??????? ???? ?? Microsoft SQL Server ??? ??????? ???????? Windows NT.
????? ???? | ?? ????

?? ??? ??????

??????

?????? ?????? ???? ?????? ????? ?? ??? ??????? ???? ?????? ?? ??? ????? ????? ?????? SQL Server ??????? ?????? ?????????. ??????? ??????? ?? ????? ??????? ?? ???? ???? ??? ??? ????? ?? ???? ???? SCSI. ????? ???? kernel ?? kernel Windows NT "?" ????? ???????/??????? "?" ?????? ????? ???? ??????? "?" ?????? ????? ??????. ???? ??????? ?? ????? ?????? ?? ?????. SQL Server ???? ?????? ??? ??????? ??????? ??????? ????? ??????? ??????? ?? ??? ??????? ?????? ?????? ????? ? ??????? ??? ???? ???? ?? ??? ???????.

????? ?? ??? ??????? ?? ??????? ????? ???????? ????? SQL Server ????? ??????? ?? ???? ????? ????.

??????? ????

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

  1. ???? ?? ?? ???? ???? ????? ?? ????? ????? ??????? (HCL). ?? ?????? ??????? ??? HCL ?????? Microsoft ? ??? ?????? ??????? ????????? ?? ???? ??????? Windows NT. ??? ??????? ??????? ???? ????? ?????? ???? ????? ?????? ????? ?????? ??? ???????? ?????? ??????? ??????? ??????? (OEM) ? ??? ?????? ?? ???????? ?????? ????? ??????? repackaged ?? ????? ????? ???? OEM ??????. ?? ???? ?? ??? ????????? ????? ?? ??????? ???? ???? ??? Windows NT ?/?? SQL Server. ????? ????? ??? ????? ?? ?? ?? ???? ?? ????? ???? ??????? ??????? ??? ???? ??? HCL ? ?? ???? ???? ??????? ?? repackaged ???? ????? ??? ??????? ???? ????? ????? ??????? ????? ????????? ??????? ???????.
  2. ????? ???? ???? ????? ?????? ?????? ???????. ???? ?? ??????? ?????? SCSI ???? ???? SCSI ??? ????? ???? ??? ????? SCSI.
  3. ???? ???? ????????? ?? ?????? ????? ??? ???????? ?? ???? ????. ???? ??? ???????? ????? ????? "??????" ???? ????????? ?? ?????? ??????? Windows NT. ?? ?????? ?????? Compaq ? ????? ??? HCL ? ??? ?? ?????? ????? ????? ?? ????? ??? ????? ?????? Compaq (SSD). ????? ??? ??? ?? ??? ??? ?????? ???? ??????? Compaq ??? Compaq.
  4. ???? ?? ?? ???? ???? ?? ?? ?????? ???? ???? ??? Windows NT. ???? ??? ???? ????? ?????? ?? ?????? ?? ????? ???? ??????:

    1. ?? ??? ????? ????????? ???? ????? Windows NT 3.5 x ??????? Windows NT ??????? ?? ?????? ??????? ??????? ?? "????? ??????? NT Windows. ?? ??????? ?????? ?? ?????? ??????? "? ???? ??? ?????/?????" ????? ??????? ". ?????? ????? ??? ?? ??? ??? ????? ???? ??????.

      ?? ??? ????? ????????? ???? ????? Windows NT 4.0 ???? ?????? ????? ?????? ?????? ?? "????? ???????" ???? ?????? ".

      ??????: ????? ?????? ??????? ?? Windows NT ???? ????? ?????? ??? ?????? ??????? ???? ?????? ?? ???? ????? ????? ??? ??????).
    2. ?? "????? ?? ???? ??????" ? ??? ?? ??? ??? ?? ???? ???? ?????? ?? ???? ????? ??? ????? ?? ????.
    3. ??? ????? Ntbackup.exe. ?? ??????? "????????" ? ???? ??? "????? ???????". ??? ?? ????? ?????? ???? ???? ? ????? ????? ?? ???? ??????? ???????? ???? ??????.
  5. ?????? ?? Ntbackup.exe. ???? ?? ??? ???? ????? ??????? ??????? ?????????? ??? ?? ?????? ?? ??????? ?? ??? ?????.

    ??????: ?? ??????? ????? ?? ?? ??? ????????.

    ????? ??? ???????? ?????? ?????? ????? ?? ????. ??? ??? ???? ??? ????? ?? ??? ??????? SQL Server ????? ?????? ??? ?????? ???? ??? ????? ?? ??? ????? ???? ????? ????.
  6. ?????? "????? ??????? SQL" ?????? ?? ????? SQL Server ?? ???? ??????? ??????. ???????? ??? ???? ??????? ?? ????? ??????? ??????:
    sp_helpdevice <backup_device_name>
    ??? ?? ???? ??????? ???? ??????? ?? ??????? ?????? ??? X ?? ??? ?????? ??????:
          \\.\tapeX
      
    ???? ???????? ????? ?????? ????? tape0... tapeX ???????? ??? ??? ????? ??????? ?????? ????? ?????? NTDetect ??? ??? ????? ??????. ???? ???? ??? ???? ?? ???? ????? ???? ????? ?????? ?????? ???? tape0 ????? ????? ??????? \\.\tape0.

    ?????? ??? SQL Server 4.2 x ????? ??? ????? SQL ???? ??? ??????? ?? ???? ????? ??????? ??? ???? ??????? ??????. ???? ?? ??? ?????? ??????.

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

??????: ??? ?? ??? ?????? ?? ????????? ??????? ??? ???? ??????. ????? ?????? ?? ?? ???? ?????? ????, ?? ???? ?????? ???? ????? ??? ????? ???? ?????. ??? ??? ?? ????? ????? ?????? ?? SQL Server ?? ????????? ???? ?? ?? ????? ?????? ???? ???????? ??????.

?????? ??? ??????? ?? ????? ???????? ??? ???????? ?? ???????? ????????? ?????????? ?? ??? ????? ??????. ???? ????? ?????? ??? ????? ?? ??? ?? ?? ??????? ??? ?????? ????? CHECKDB DBCC NEWALLOC DBCC.

???? ????? ??? ????????? DBCC ?? ????? ?????? ???????? ??? ?????? ?????????? ???????. ?? ????? ????? ?????? ???????? ?? ????? ?????? ?? ????? ????? ????? ???????? ??? ?????? ????? ????? ?????? ?? ???? ???? ???.

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

  1. ??? ????? ?? ???????? ??????? ????? SQL Server ????? ??? ??????? ???????? ?? SQL Server ? SQLExecutive (?? ???? ????? SQL ?? SQL Server 4.2 x).
  2. ????? ????? ??????. ????? ????? 60 ????? ?? ????? ?????? ??? ????. ??? ??? ?????? ??? ???? ????? ???? ?????? ?????? ????? ?? ????? ??? ?????? ??????? ??? ????? ??????. ???? ??? ???? ???? ???? ???? ????? ???? ???? ??? ???? ??? ????????? ?????????? ???????.
  3. ??? ????? ???? SQL ?? ????? ??? ???? ???????.
  4. ????? ?????? ??? SQL Server ?????? ?????? (SA) ?? ????? ??? ???? ????????? ISQL/?????.
  5. ????? ???????? ??????? ?? ???? ????????? ISQL/?????:
          dump database pubs to tapedump with init,nounload
          go
      
    ??????: ??????? tapedump ?? SQL Server ??? ???????? ????? ??? ???????.

    ??? ?? ????? ??????? ???????:
    msg 4029 ? ??????? 10 ?????? 1:
    ????? ????? ?????? pubs (???????? ')' (????? 89) ??? ??? <1>??? ?????? 'SQ0001'.
    ?????? SQL Server ????? ??? ??????? ??? ?? ???? ??????? ??????:
          94/02/01 15:49:08.83 kernel   Tape pubs SQ0001 mounted on tape
                                        drive \\.\TAPE0
    
  6. ??? ???? ???? ????? ????????? "??" ????? ?? ????? ??????? SQL ?? ?? ???? ???? ???? ????? ?????????. ???? ?? ??? "????? ???? ???????" ??? ????? ???.
  7. ??????? ??? ???? ????????? ISQL/????? ?????? ???????? ???????:
          dump database pubs to tapedump with noinit,nounload
          go
          dump database pubs to tapedump with noinit,nounload
          go
      
    ??? ?? ????? ??????? ???????:
          Msg 4029, Level 10, State 1:
          Database 'pubs' (89 pages) dumped to file <2> on tape 'SQ0001'.
          Msg 4029, Level 10, State 1:
          Database 'pubs' (89 pages) dumped to file <3> on tape 'SQ0001'.
      
    ???? ??? ????? SQL Server ??? ?? ???? ????? ??????? ???????:
          94/02/01 15:49:08.83 kernel   Tape pubs SQ0001 mounted on tape
                                        drive \\.\TAPE0
          94/02/01 15:50:18.83 kernel   Tape pubs SQ0001 mounted on tape
                                        drive \\.\TAPE0
      
    ??? ?? ????? ??? ????? SQL Server ??? ??????? ?????? ??????? ??????? ???? ??? ??? ?????. ????? ??? ????? "?????" ?? ??? ???????.
  8. ??????? ??? ???? ????????? ISQL/????? ?????? ???????? ???????:
     
          load database pubs from tapedump with file=2,nounload
          go
      
    ???? ??? ????? SQL Server ???? ??? ??????? ????? ?????? ??? ???:
          94/02/01  15:49:08.83 server   Recovery dbid 4 ckpt (1017,8)
      
    ??????: ?? ????? ???????? ??? dbid ????? ?????? ??? ????? ??? ??????? ??? ????????? ???????? ?? ??? ???????. ???????? ??? ???? ?????? ckpt ?? ????? ?? ???? ??? ???? ?????? ??????? ???? ?? ?????? ????? ????? ????? ????????? ??? ?? ????? ?????.
  9. ?????? ?????. ??? ??? ???? ????? ?? ? ???? "??????" ??? ?? ??? ???????.

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

?????? ??? ?????? ?????? ??????. ?????? ?? ??? ??? ??????, ??? ??? ????? ?? ?????? ?????? ?????? ???? ?? NTBackup ??? ??????? ?????? ????????? ??????? ??????????. ?? ???????? ?? ?? ???????? ??????? ?? ????? ?????? ??????? ?????? ?????? ??????? unproved.

????? ??????? ???????? ??????? ???? ????? ?? ??? ????? ???????? ???????? ? ????? ????? ?? ??? ???????. ??? ???? ??????? ??????? ??? ?? ??????? ???????? ????? ????? ?????? mirrors ??????? ?? ????? ?????? ??????? ?????? ?? ??? ?????? ??? ????????. ?? ????? ????? ?? ???? ?? ?? ??? ???? ??????? ?? ????? ?????? ??????? ?????? ??? ????? ??? ??????.

????? ????? ??? ??????? ?????? ??? ??????? ??????? ????? ?????? ?????? 2. ?????? ?? ????? ???????? ???????:
  1. ????? ????? ???? SQL ?? ????? ????? SQL ?? ?? ???? ??????? ???????? ??? NET MSSQLSERVER STOP (?? SQL Server 4.2 x ????? ?? NET SQLSERVER STOP).
  2. ???????? Ntbackup.exe ? ????? ???? ????? ?????? ?????? ???????? ??? ?? ??? Master.dat ??? ????? ????????? tempdb. ??? ?? ??? ????? ??? ??????? ?? ???? ?????? NTBackup.
  3. ??? ????? SQL Server ?? ???? "????? ????? SQL" ?? ?? ???? ??????? ?? ??? MSSQLSERVER START NET.
  4. ?? ?????? ??????? 1-0 ??? ?? ???? ?? ????? "????? ?????? ????????" ?? ??? ??????? ??????? ????? ???????? ??????? ?????? ???????? 'pubs (????????)'.

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

??????? ?????? ??????? ???????? ??? ????? ????? ?? ???? ?? ??? ?? ???? ???? ????? ?? SQL Server ????? ?? ????? ?????? ??? ??????. ????? ?????? ?????? SQL Server ??? ??????? ??????? ???? ??????? ???????? ???? ????? ?????? ?????? ???????? ??? ????? ?????? ???? ?? ??????? ??????.

?????

  1. ?????? ??? ?????? ???? ??????? Windows NT (????? ??? ????? ??????) ???????. ??? ?? ??? ?? ?? ???? SCSI ?? ????.
  2. ?????? ??? ????? ???? ??????? Windows NT ??????? ?? ??? ????? SQL Server.
  3. ?????? ??? ????? SQL Server.
  4. ??????? ????? ??????? ???????? ????? ?? ?? ???? ???? ??? ????? ????? ?????? ?? ?????? ??????? ???? ??????? ??????? ?? ????? ????? ???????.
  5. ??? ?? ????? ????? ??? ?????? ???????? ??? ????.
  6. ???? ???? ?????? ????????.
??? ??????? Microsoft SQL Server ??? ? ?? ???? ?????? ??????? ????? ????????? ???????:
  • ??????? ??????? ??????? ?? HKEY_LOCAL_MACHINE\Hardware\Devicemap ??? ???? ??????. ????? ?????? ????? ????? ?? ??? ? ? ??????? ????????? ????? ???? SCSI ??? ?? ????? ?? ??????? ??? ???? SCSI ? SCSI ??????.
  • ??? ????? ? ??????? ? ????? ?????? ??? ?????? ????? ??? ????????? ?? ??? ?????? ???????.
  • ????? ?? ??????? ?????? ????? ?????? ???????? ??? ??? ????? SQL Server ? ??? ?????? ? ??? ??????? ?? "???? ???????".
  • ???? ????? ???? ?????? ?? ???? ????????? (not ????? ???? ???????? ????????).
  • ??????? ?? ??????? sp_helpdevice ? xp_msver.

???????

???? ???????: 124023 - ????? ??? ??????: 11/???? ??????/1435 - ??????: 4.0
????? ???
  • Microsoft SQL Server 4.21a Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbusage KB124023 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????124023

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