??? ???????? ??????? ???????? "????? ????? ????????" ??? "?? SQL Server 2000

???? ???????: 274463 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

????? ??? ????? ???????? ?? ???? ?????? ????? ?? SQL Server 2000 ???? ???? ?? ???? ?? ??? ????? ?????? ?? SQL Server 7.0 ?? ?? SQL Server 2000 ??? SQL Server 2000. ????? ????? ?? ????? ?????? ?????? ???? ?? ???? ??? ?????? ??????? ???? ?? ???. ???? ??? ??????? ????????? ??? ??? ???? "????? ????? ????????" ??? "? ???? ??? ???????? ?? ??? ??????? ???????.
???? ??? ?????? | ????? ???????

??????? ????

??? ???? "????? ????? ????????" ???? "

???? "????? ????? ????????" ??? ":
  • ?? SQL Server "??????? ?????" ? ???? ??? ????? ?? ???? ??? ????? ?????.

    - ?? -

  • ???? ??? ?????? ?????? ??? ???? ????? ?????? ? ???? ??? ???? ?????? ?? ???? ??? ??? ????? ????? ????????....

    - ?? -

  • ?? ???? ???????? ???? Cdw.exe ?? ???? ????? Enter.
???? ????? ???????? ???? ??? ??? ?? ??? ?? ??? ??????? ???????? ?? ????? ???????? ??? ?????? ?????? ??????? ????? ?? ????? ????? ????????. ??? ????? ?? ??? ?? ????? ????? ???????? ?? ???? ????????? ??????? ???????:
  • sp_detach_db

    - ? -

  • sp_attach_db
????? ?? ????????? ??? ??? ????????? ??????? ???? ???????? "sp_attach_db" ? "sp_detach_db" ?? "??? SQL Server ???????".

???? ????? ??????? ?? ????? ??? XP_CMDSHELL ???? ???? ??? ??? ??? ?????. ??? ??? ???? ?? ????? ?? ?????? ???? ??? ????? "????? ????? ????????" ??? memeber ????? ??????. ????? ?? ?????????? ???? "??????? ??? ????? ????? ????????" ?? "??? SQL Server ???????".

??????? ?????? ??????? ???????:
  1. ????? ???? ?????? UNC ??? ????????? ?????? ??? ???? ??????? ?????? ?????.
  2. ??????? ??????? ???? ?? ????? ???????? ??????.
  3. ??? ????? ???????? ?? ??? ???????? ??????.
  4. ???? ????? ???????? ??????.
  5. ??????? ??? ??????? ?????? ?? ?????? ?? ??? ????? ????? ???????? ??? ???????? ??? ?? ?????? ??????.
  6. ????? ????? ???????? ??? ???? ??? ?????? ??????.
  7. ????? ????? ???????? ??? ?????? ??????.
  8. ????? ?????? UNC.
  9. ??? ????? ???????? ??? ???? ?? ??? ?????? ????? ?? (???????? ?????? ????? ? ???).
???? ???? ????? ?????? ???? ?? ??? ???????? ???????? ?? ????? ???????? ???? ??? ????? ?? ?????.
  • ??????? ?????? (??????).
    • ??????? ?????? ???? ?????? ?? ??? ??????? ??????.
    • ??????? ??? ?????? ????????? ?? ??? ????? ???????? ???????.
  • ?????? ????????? ??????? ?? ????? ???????? ???????? (???????).
    • ????? ???? ????????? ???? ?? ????? ?? ????? ??? ??????? ??????.
    • ????? ???????? ????????? ???????.
  • ???? ?? msdb (???????).
    • ???? ???? ?????? ?? ??? ??????? ??????.
    • ????? ???????? ????.
  • ????? ??? ????? ?? ??? ???????? (???????).
    • ???? ????? ??????? ?????? ?????? ?? ??? ??????? ??????.
    • ????? ????? ????? ????????.

????? ????? ???? ????? (DTS) ????? ????????

???? "????? ????? ????????" ??? ???? DTS ???? ??? ?????? ??? ?????? ?????? ???? ????? ??? ??????? ?? ???? ?????? ???? ??????? ??????. ???? ????? ????? ?????? ????? ???? ?? ????? ?????? DTS ?????? ???????? ???? ???? DTS ?????? ??? ??? ?????? ????? ????????. ????? ?? ?????????? ???? ??????? ??? ?????? ?????? ????? ???????? ?? SQL Server 2000 ????????.

??? ??? ?????? ??? ????? ??????? ???? ????? ?? ??? ?????. ????? ????? ???? ???? SQL ??? ?????? ?????? ????. ??? ?? ??? ?????? ???? ????? DTS ????? ?? ???? DTS ??? ?? ??? ??????? ????????? ???????? ???????? ????? ??????. ?????? ??? ???? ?? ????????? ??? ????? ??????? ????? ???????? ????? ??? DTS ???? ??????? ??????? ?? "????? ??????? ?? Microsoft":
269074
(http://support.microsoft.com/kb/269074/EN-US/ )
INF: ????? ????? ???? DTS ?????? ???? ??????
????? ??????? "????? ????? ???????? ???" ?? Microsoft SQL Server 7.0 ??? ?????? ???? ?? ???? ???? ????? ?????? ???? ???. ?? ????? ??????? ??????? ?? ??????? Microsoft SQL Server 6.x ?? ????? ????.

??? ????? ????? ????? ???????? - ??? ???? DTS

??? ????? ??? ??????? CDW ?? MSDBsysdtspackagelog ???? ?????? ??? ????? ???? ?? ???? ????? ??????? ?? SQL (SEM). ???? ????? ???? ??????? ???????:
  1. ??? ?????? ?????? ??? ??? ????? ?????? ???? SEM ?? ?? ?????? ?????? "????? ????? ????????".
  2. ??? ????? ??????? ?????? ???? ?????? ???? ???? ??? ?????. ???? ???????? ??? ????? ????? CDW_SourceServer_DestinationServer_autonumber.
  3. ???? ??? ?????? ?????? ??? ?????? ?? ??? ?????? ????? ?????.
  4. ??? ??????? ???? DTS ? ???? ????? "? ???? ??? ????? ????? (+) ?????? ?????? ???? ????? ?????.
???? ???? ?????? ??? ???? log(s) ??? ?????? ?? ??? ???? ???? ?? ?????? ???????. ??? ???? ?? ???? ??????? ???? ?? ????? ?????? ??? ???? ???.

???? ????? ????? ????? ???? DTS ?????? ??? ????? ???? troublshooting.
  1. ???? ??? ?????? ?????? ??? ?????? ? ??? ???? ???????.
  2. ?? ??????? "????" ? ??? ?????.
  3. ?? ??????? ????? ? ??? ??? ?????.

    ??? ????? ??? ???? ??????? ??????? ??? executation ??????.

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

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

??? ??? ??? ????? SQL Server ?????? ??? ???? ???? ???? ?? ????? ????? ????? ???????:
??? ????? ???? ???? SQL ?????? ?? ??? ???? ?????? ??????. ????? ??? ????? ???? ???? SQL Server ????? ?? ???? ???? ??? ???? ??? ??????? ??? ??????.
??? ??? ??? ????? SQL Server ?????? ??? ?? ??? ????? ???? ???? ??? ???? ???????? ??????? ?????? ??? ????????? ?????? ????? ????? ??????? ?? ?????? ???????:
???? ????? ??????: ???? ????? ????? Microsoft ???????? (DTS)
??? ????? ??????: ??? ??? ????

?????? ??? ?????: 80004005
?????? File:sqldts80.hlp ????????? ???
?????? ID:1100 ???? ????????? ???
????? ??? "INFO ?????? >>>" ???? ? ???? ?????? ?????? ?????? ????? ??? ??????.
??? ?? ????? ?????? OMWWIZD

???? Aware ???? ????? ????????

??? ???? ?????? ???? "????? ????? ???????? ???" ????? ???????? ?????? ??? ???? ??? ?????? ??????. ?? ??? ?????? "????? ????? ????????" ??? "??? ???? ????? ???????? suspect" ?? ?? ???? ???? ??? ????? ???? ?? ????? ???????? ???? ?? ???? ?? ??? ?? reattaching. ?? ???? ??????? ??? ????? (??? ???? ??????? ??? 823) I/O ????? ????? ???????? (??? ???? ??????? ???? ????) ?? ?? ???????? ?????? ??????? (??? ???? ??????? ????? ???? SCSI ?? ???? ???? ??????? ?? ??? ????? ??????) ? ??? ??? ????? ? impediment ??? reattachment ????? ?? ????? ????????.

???? ?? ?? ????? ???????? ?????? ?? ??? ??? ????? '??????? ???' ? '??? ?????' ?? '???' ? '???????' ?? '?????' ?? ?? ??? ?????. ??? ??? ??? ??????? ??? ??? ????? ?????????? ?? ????? ????????; ??? ???? ????? ???????? ?? ?? ????? ?? ???? ?????? ??? ?????? ??? ?????? ??????? ??? ????? ??????????. ??? ????? ????? ????? ??????? ??? ???? ??? ???? ????? ???????? ?? ?? ???? unwritable:
??? ?? ??? ????? ???????? <databasename>
???? ???? ??? ????? ???????:
???? ????? ??????: ???? ??????? (DTS) ????? ?????? Microsoft
??? ????? ??????: ??? ??? ????

?????? ??? ?????: 80004005
?????? File:sqldts80.hlp ????????? ???
?????? ID:1100 ???? ????????? ???
???????? ??? ???? ??? ????? ???????? ????? ?? ???? ?? ??? ???????? ?????? ?? ?? ?????? ??????? ??. ?????? ?? ?????????? ??????? ????? ???????? ?? ???? ??????? ???? ????? ??????:
???? ????? ??????: ???? ??????? (DTS) ????? ?????? Microsoft
??? ????? ??????: ??? ??? ????

?????? ??? ?????: 80004005
?????? File:sqldts80.hlp ????????? ???
?????? ID:1100 ???? ????????? ???
??? ??? ?????? ??? ???? "??????? ??????" ? ????? ?????? ??????? ????? ??? ???????:
????? ????? ???????? [dbname] [N] ??????? ????. ?? ??? ??? ????? ????????.

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

????? ??? ???????? ??? ????? ??????. ???? SQL Server 2000 ???????? ???????? ???????? ???????? ???????:
"????????" ????? ????? ???????? ??? "??? ?? ???? ????? ???? ?? ????? ??? ????? ??????. ??? ??? ???? ?????? Microsoft Windows NT ® 4.0 ?? Microsoft Windows ® 2000 ??? ?? ???? ???????? ????? ?? ?? ???? ???????? ??????? ??? ?????? ??????."

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

??? ??????? ?? ??? ????? ???????? ????? (CDW) ? ?? ???? ???? ??? ????? ???????? "? ???? ??? ????" ????? "????? ?? ??? ???? ??????. ??? ??? ?????? ??? ?????? ?? ???? CDW ???? ????? ??????:
????? ?????? Microsoft ???? ????? ??????: ???? ??????? (DTS)
?????? ??? ???: ??? ??? ????

?????? ??? ?????: 80004005
?????? File:sqldts80.hlp ????????? ???
?????? ID:1100 ???? ????????? ???
??? ??? ?????? ??? "INFO ?????? >>>" ???? ? ???? ?? ?????? ??? ?????.
?? ???? ??? ????? \\SOURCE_SERVER\OMWWIZx\Program Files\Microsoft Server\MSSQL\Data\Filename_Data.mdf SQL ??? ???? ?????? ??? ?????.

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

???? ???? ??? ??? ????? ??? ????? ?????? ????? ?? ????? ??? ????? ????? ???????? ?? ???? SQL Server ??????. ????? ???? ???? ??? ??? ?? ?????? ?????? ????? ???????? ???? ?? reattached. ??? ????? ?? ???? ??? ????? ????? ???????? ??????? (.mdf .ndf ? .ldf) ??? ?????? ?????? ????? ??? ?? ????? ??? ????? ???????? ????? ????? ??????. ???? ????? ??????? ??????? ?? ???? ?????? ????? "????? ????? ????????" ??? ":
???? ??? ????? ???????? 'Pubs' ???? ???? ?????? ??? ??? ?????? ??????. ??? ??? ??????? ??? ???????? ?????? ??????? ?????? ???????? 'Pubs' ??? ?????? ??????.
????? ??? ???? ??? ??? ?????? ?????? MOVE ????? ?? ?????? ??? ?? ???? ????? ? ???? ???? ????? ????? ??? ??????? ??? ???? ??????? ????? ????????.

??? Logins

???? ????? ?? "????? ????? ????????" ??? alleviates ??????? ?????? ??? ??????? ??????. ??????? ????? ??????? ?????? ???????? ?? ??????? ????? ???????? ????? ?? ???? ??? ?? ??? ??? ???? ?? ??? ?? ??? ????? ????????. ??? ??? ?? ?? "??????? ?????? ?????? SQL Server ?????" ? "Microsoft Windows NT" ? "Microsoft Windows 2000 ??????? ?????? ???????? ?????? ???????.

????????? ??????? ?? SQL Server ????? ???? ???? ???? ??????? ?????? ???????? ?? ??????? ????? ???????? ?? ????? ???????? ??? ????? ?? ?????. ????? ?? ????????? ??? ??? ??????? ?????? ?? ????????? ??????? ?? SQL Server ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
168001
(http://support.microsoft.com/kb/168001/EN-US/ )
PRB: ????? ???? ???????? ?/?? ??? ????? ??? ??????? ?????
246133
(http://support.microsoft.com/kb/246133/ )
??? HOW TO: Logins ?????? ??? ?????? SQL Server
???? ??? ????? ??? ??????? Windows NT/2000 ??????? ??????????? ????? ?? ????? ???? ????? ?????? ??? SQL Server ?? ??? ????? ??????? ??????. ??? ????? ?????? ????? ????? ????? ????? ??????. ??? ??? ?????? ??? "INFO ?????? >>>" ???? ????? ?????? ??? ??????? ????? ???????:
"???? ????? ??? SourceMachine\LocalGroup1 ????? ??????"
- ?? -
"??? ????? ?????? SourceMachine\LocalUser1 ???"

???? ????? ????? ???????? ?? ???? "????? ????? ??? ?????"

??? ??? ????? ?????? ? ???? ??????? ?? ?? ????? ?????? ?????? ??? ?????? ??????. ???? ???? ?????? ????? ????? ???????? ??? ??? ?? ??? ??? ??? ????? ???????? ?????? ????? ?? ????? ?????? ????? ??? ??? ??? ????? ???????? ?????? ?????? ?? ?? ????? ?????? ?????? ??? ????? ???????? ????????.

???? ????? ????? ????? ??? ????? ?????? ?? ???? ???? ????? ????? ???????? ??? ?????? ??? ?????? ??????. ???? ?? ???? ???? ????? ?????? ????? ???????? ??????? MyPubs ?? ????? ??????? ?????? ??? Pubs ??? ??????. ??? ????? ??? ??????? ??????? ???? ???? ??? ????? X ?????.
"??????? ??? ?????? ??? ??? ????? ??? ?????? ?? ?? ???? ????? ??? ??? ????? ??? ??????."
????? ????? ??????? ?????? ??? ??? ????? ????? ????? ???? ????? ??? ?????? ?????? ?? ????? ???? ???? ??? ???? ???? ??????? ???.

???? ????? ?? ???? ????? ??? hampered ???? ??? ????? ????? ??? ?????? ??????. ????? ?????? ??????? ?? ??? ??? ??????? ????? ?????.

???? ??? ?? ????. ?? ??? ????? ????? ???????? ???? ????

??? ???? ????? ???????? ????? ??? ??? ????? ????? ???? ?????? ???? ??????? ????? ?? ??????? "????? ????? ????????" ??? "???? ????. ?????? ????? ??????? ??????? ???? ???? (FT) ?? ????? ?????? ??????? ???? ??? ????? ???????? ?? ??? ???????? ??????. ??????? ?? ??? ??? ????? ???????? FT ?????? ???????. ??? ????? ????? ??????? ??? ?? ???? ??? ???? SQL ?????? ?? ?????? ??? ????? "????? ????? ????????" ??? ?? ???? ??? ????? ????? ???????:
????: ????? 7616 ? ????? 16 ???? 1? ????? 1
?? ??? ????? "???" ???? ?????? ?????? ???????? ???????. ??????? sp_fulltext_database ?????? ????? ?? ?? ???? ?????? ????????.
????? ?? ?????????? ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
303224
(http://support.microsoft.com/kb/303224/EN-US/ )
FIX: ????? ?? ???? ??? ????? ???????? ?????? ?????? ??????? ????? ????? ???????? ??? ??? ????? ??????
????? ??? ?? ???? ??? ?????? ??????? SQL Server ?????? ?????? ??????? ???????:
  1. ????? ??????? ?????? ??????? ?????? ??????? ??? ????? ?????? ???? ?/?? ?????? ???? ??????: 
    sp_fulltext_database 'enable'
  2. ????? ?????? ????? ??? ???? ??????? ???????.
????? ??? ?????? ??? ????? ?? "??? SQL Server ???????":
"??? ??? ???? ?? ??? ????? ?????? ?? ???? ?????? ??????? ??????? ??????? ??????? ???? ?????? ?????? ???????? ??? ?????? ??? ?????? ?????? ??? ????? ????? ?????. ??? ?? ?????? ????? ??????? ??????? ???? ?????? ??? ?????? ??????.

??? ??? ???? ?? ??? ????? ?????? ?? ??????? ??????? ???? ?????? ??? ??? ?? ?? ??????? ???????? ?????? ???? ?????? ??? ??? ????? ????????. ??? ??????? ??? ??? ?????? ?????? ????? ????? ????????."
????? ?? ????????? ??? ????? ??? "????????" ?? ???? ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
240867
(http://support.microsoft.com/kb/240867/EN-US/ )
INF: ????? ??? ??? ? "?" ?????? ?????? ?????? ????? ???? ?? "?" ?????
???? ??? ?????? | ????? ???????

?????

?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
327270
(http://support.microsoft.com/kb/327270/EN-US/ )
?? ??? ????? SQL Server 2000 ??? Windows Server 2003 Terminal ????? ?????? Server
???? ??? ?????? | ????? ???????

???????

???? ???????: 274463 - ????? ??? ??????: 19/?? ??????/1426 - ??????: 6.3
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbinfo KB274463 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????274463
(http://support.microsoft.com/kb/274463/en-us/ )
???? ??? ?????? | ????? ???????

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

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