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

?????? ????????? ?????? ?????????
???? ???????: 169039 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???? ??? ??????? ????? ??????? ??????? ????????? ????? ????? ??? ??????? ???? ?? ?? ???? ???????? ????? ????? ?????? ???????? ???????? ?? ??? ??? ???? ???????. ??????? ?????? ????? ??????? ?????? ???????? ????? ?????? ????????; ????? ?????? ?????? ????? ??????? ??? ???? 24 ????.

??? ???? ?? ??? ??????? ???? ???? ????? ????? ?????? ??????? ??? ??? ????. ?? ????? ??? ?????? ??? ??????? ??????? ????????? "????? ??. ??? ???? ?????? ??? ?? ???? ?????? ?? ?????? ????? ???? ????? ?????.

??????? ????

??????? ????? ???? ??? ?????? ???? ???????? 24 ????. ?? ????? ??????? ? ????? ??? ?????? ??????? ???????? ??? ?? ?????? ????? ?? ? ??? ???????? ???? ???? ?????????? ??? ? ??? ?? ???? ??? ??? ???????? ??????? ?? ????? ?????? (SA) ????? ???? ?????? ????? ????? ????? ???????? (DBA) ?? ?????? ??? ?????? ?????? invaluable. ??????? ??? ??? ???? ?? ??????? ?????? ????????? ???? ??? ??????? ????? ????? ???? catastrophe: ??? ??? "?????? ?? manmade ???? ??? ????? ?? ??? ??? ???? ?????? ??? ??? ????? ????? ?? ???? ????? RAID-5. ????? ????????? ??? ??? ???? ?? ??? ?????? ??????? ???? ????????? ???? ????? ??????? ???? ???????. ??? "????? ?????????" ??? ??? ???? ?????? ????? ??????? ?/?? ????? "??????? ????????? ??????? ????" ????? ??????? ????? ???????? ????????? ??????.

????? ?????? "??? ??????? ??????? ?????????" ??? ????? ????????? ????? ??? ?? ???? ?????? ???????? ????? ???? ????? ?? ??????????. ??? ???? ??????? "??? ?????? ??? ?????? ?????? ??? ??????? ????????? ?? 48 ???? ? ???? ???? ???? ???????? ??? ??? ????? ??????? ??????." ?? ????? ????? ?? ??? ???????? ????? ?????? ???? ???? ?? ??? ?????????. ??? ?? ???? ?????? ??? substantiate ????????? "????? ?????????" ??? ??? ????.

???? ???? "??? ??????? ??????? ?????????" ???? ??? ?????? ????? ?? ????? ??? ?????? ?? ????? ????????? (????? ?????? ??? ?????? ???? ?? ??????? ??, ?? ?? ??????? ??????? ?? ???? ??? ??? ???? ? ??? ??? ???? ???????, ???? ???? ??????? ??? ?????). ??? ??????? ??? ??????? ??? ??? ??? ??? avenues ?????? ???????? ?????? ?? SQL Server.

?????? ?? ???? ??????? ???? ?? ???? ??? ???? 24 ???? (?? ??????? ???? ????? ??? ?????? ??????? ????????):

?????? ??? ??? ??? ???? ??????? ?? ??? (?? ????? ???? ???? ???????):
  1. ??? ???? ????? ????? SQL Server.
  2. ??? ???? ????? ?????? ?????? ???????? preferably ??? ??????? ??? ?? ???? ??? (???? ????? ?? ????? ???? ???????) ? ??? ????? ??? ???? ???? (?? ?????? ????? ???? ???? ??? ??????? ??? ??? ????? ????).
  3. ???????? ??? ????? ?????? ?????? ????. ????? ?????? ??? ???? ??????? SQL Server ???? ??? ????? Master.dat ????. ??? ????? ???? ??? ?????? ????? ??? ?? Windows NT Server ? SQL Server. ???????? ??????? Net ???????? ????????? ? ??? ???? ???? ???? ????? ?????? (SA).
  4. ???????? ??? ?????? ??? ????? ?????? ?????? ??? ????? ???? ?????? ????? (???? ???????? ?? ????? ??? ???????).
  5. ?????? ???? ???????? ??? ????? ????? ???? ?????? ????? ??? ????? ???????? "?" ????????? ????? ???? ?????? ??????. ???? ?? SQL Server ????? ??? ?????? ?????? ??? ???? ?? ????????? ??? ??????? ????? ??????? ??????????.
  6. ????? ??? ??? ???? ????????? ??????? ??????? ??????? ????? ??? ???? ??? ?? amend ??????? ??? ???????.
???????? ??? ??? ??? ??? ???? ?? ??? ??? ??? ?????? ??? ??????? ????????? ?????:
  1. ?? ?????? Windows NT Server ?? ????? ???? ?????? ????????. ???? ?? ???? ????? ?????? ???????. ??? ???? ??????, ???? ?? ??? ????? ?????? ???? ???? ????.
  2. ????? SQL Server ?????? ????? ???? ?????? ????????. ?? ???? ???? ????? ???????? ???????? "?? ??? ?????? ??? ?? ?????? ???? ???. ????? ????? ????? Net ???? ? ??? ???? ? ???? ?????? SA ?? ???.
  3. ???? ?? ????? ???? SQL ???? ????. ??? ??? ???? Windows NT ?? ????? ??? sp_dropserver ????????? ? sp_addserver ??????? ??? ???? Windows NT.
  4. ????? ???? SQL.
  5. ??? ???? ????? ????? ?????? ?????? ??? ???? ??? ??????? ??????? ??? ?? ??? ????? Master.dat.
  6. ????? ????? SQL Server.
  7. ?? ???? ???? ??? ????? ????? ???????? ?? ?????? ??? ??? ????? ????? ?????.
  8. ???? ?? ???? ??????. ????? ???????? ??? ????? ?????? ?? ??????? ????????. ????? ?????? ??? ????? ?????????? ??? ??????, ??? ?? ??? ????? ????? ?????? CHECKDB DBCC ? NEWALLOC ??? ?? ????? ????????? TEXTALL DBCC ? TEXTALLOC ??? ????? ???????? ?????? ??? ???? ????? ??? ???? TEXT. ??? ?????? ?? ??? ?? ??? ????? ??????? ?????? ??????? ?????? ??? ????? ????.
  9. ??? ????? ?????? DBCC ????? ????? ???????? ??????? ???? ???????? ????? ?????? ????? ???? ?????????? ???????.
?????? ???? ??????? ???? ????? ??? ?? ?????? ??????? ??? ???????? ?????? ???? ???? ?? ??????? 24 ???? ?? ?????:

?????? ??? ??? ??? ???? ?????? ??? ???:
  1. ???? ???? ????? ???? ????? ???????? preferably ??? ??? ??? ??????? ??? ?? ???? ??? (???? ?? ????? ?? ????? ???? ???????) ? ??? ????? ??? ???? ????. ???? ?? ??? ?????? ????? ????????? ???? ?????.
  2. ???????? ??? ????? ?????? ?????? ????. ????? ?????? ??? ???? ??????? SQL Server ???? ??? ????? Master.dat ????. ??? ????? ???? ??? ?????? ????? ??? ?? Windows NT Server ? SQL Server. ???????? ??????? Net ???????? ????????? ? ??? ???? ???? ???? ????? ?????? (SA). ??? ????? ?????? ????? ???????? ???????.
  3. ????? ????????? ??? ???? ????? ???????? ???????? ALL ?? ??????? ??????. ??? ????? ?????? ????? ????????? ?? ??? ??????!
  4. ???????? ??? ?????? ??? ????? ?????? ?????? ??? ????? ???? ?????? ????? (???? ???????? ?? ???? ??? ???????).
  5. ????? ??? ??? ???? ????????? ??????? ??????? ??????? ????? ??? ???? ??? ?? amend ??????? ??? ???????.
??????? ??? ??? ??? ??? ???? ??? ?????? ??? ??????? ?????:
  1. ?? ?????? Windows NT Server ?? ????? ???? ?????? ????????. ???? ?? ???? ????? ?????? ???????. ??? ???? ??????, ???? ?? ??? ????? ?????? ???? ???? ????.
  2. ????? SQL Server ?????? ????? ???? ?????? ????????. ???? ?? ??? ???? ????? ???????? ???????? ?? ??? ?????? ???. ????? ????? ????? Net ???? ? ??? ???? ? ???? ?????? SA ?? ???.
  3. ???? ?? ????? ???? SQL ???? ????. ??? ?? ????? ??? Windows NT Server ????? sp_dropserver sp_addserver ??????? ??? ???? Windows NT.
  4. ????? ?? ????? ???? ??????? ?????? ???????? ?? ??????? ?????? ???? ?? ??????? ?? ?????? 3 ?????? ?????? ?????. ???? ????? ????? ?????? ???????.
  5. ??? ???? ???? ????? ??????? ?????? ??? ???? ?? ??? ????? ??????? ??? ???? ??????? ????? ???? ???????? ?? ??????? ????? ???? ?????? ?????? ?????? ?? ????? ???????? ???????? ???????, ???? ?????? 5a. ????? ??? ?? ??? ????? ???? ?????? 6.

    1. ????? ???? SQL.
    2. ??? ????? SQL Server ?? ??? ???????? ???? ?? ??? ??????? "SQLSERVR - c -m".
    3. ??? ????? ????? ???????? ???????? ?? ????? ?????? ??? ??? catastrophe.
    4. ??? ????? ????? ?????? SQL Server ???? ????. ???? ?????? 6.
  6. ????? ?? ?? ????? ?????? ???????? ?? ??????? ??????? (? ????? ??? ????????? ?????? ??? ??? ???????).
  7. ????? ?????? ????? SQL Server.
  8. ???? ?? ???? ??????. ??? ?? ?? ????? ????? ????? ???????? ???????? ?? ?????? 5 c ????? ?????? ????? ???????? ??? ????? ??????. ????? ???????? ??? ????? ?????? ?? ??????? ????? ?? SQL Server. ????? ?????? ??? ????? ?????????? ??? ??????, ??? ?? ??? ????? ????? ?????? CHECKDB DBCC ? NEWALLOC ??? ????? ?????? ?? ? TEXTALL DBCC ? TEXTALLOC ??? ??? ????? ???????? ??????? TEXT ???? ????? ??? ????. ??? ?????? ?? ??? ?? ??? ????? ??????? ?????? ??????? ?????? ??? ????? ????.
  9. ??? ????? ?????? DBCC ????? ????? ???????? ??????? ???? ???????? ????? ?????? ????? ???? ?????????? ???????.
????? ????????? ??? ??? ???? ???? ???? ????? ??? ????? ?????? ??? ??????? ?????, ????? ??????? ????????? ??? ??? ???? ??????? ? ?????? ????? ??????? SA ?? DBA (??? ??? ????? ?? ????? ???) ??????? ?????? ??? ??? ?????????. ????? "??????? ??????? ??????? ?????????" ????? ?????? ?? ??????? ?? ?????? "??????? ????????? ??????? ????".

??? ???? ???????? ??????? ?? overstated ????? "????? ??????? ??????? ?????????". ?? ?? ????? ????? ??? ??? ?? ????? ?????? ??? ???????? ?????? ?? ??? ???? ? ?? ??????? ?? "????? ?? ???? ????? ?? ?????? ??? ?????? ????? ?? ????? ????????? ??????" ? ??? ??? ???? ????? ?? ???????? ????????? ?????; ????? ????! ??? ??????? ???? ?????? ??????? ????? ?? ???? ????? ??????? ? uncertainty ???????? ?????? ??? catastrophe ??????????.

??? ????? ??? ??????? ??? ????? ?????? "??????? ????? ????????" ?? ?????? 48 ?? ???? ????? Microsoft SQL Server 6.5 (?????? ??? ????? ?? http://www.microsoft.com/sql/deploy.htm). ???? ?????? ??? ??????? ?????? ??? ????? SQLSERVR ????? ????? ???????? ???????? ?? "??? SQL Server ???????" ?? "?" ?? "????? ??????? ?? Microsoft.

??????: ???????? "?????? ??????? ????? ???" ?? ???? ?? ????????? ???????? ???? ???? ????????? ?? ????? ??? ???? ????? ?? ????? ???????? ?? ????? ????? ????. ??? ??? .sql ?? ????? SQL ?????? ????? ??? ?????? ?? ISQL ?????? ??????. ???????? ????????? ??????? ??? .bat ???? ???? ?????? ???? ?? ????? ??? ??????? BCP ? ISQL. ??? ???????? ????? ?????? ??????? ??????? ???? ?????? ???????? ???? ???? ??? ????? ??????. ??? ???? ??????? ??? ???? ??? ????/?????? ???????? ????? ??? ?? ???? ???? ????? ?? ????? ??????? ?? ???????????; ?????? ??? ???? ??????? ??? ?????? ?????? ??????? (OLTP) ?? ???? ????? ???? ??????? ??????? ????? ?????? INSERT ? UPDATE ? DELETE. ????? ?????? ??, ?? ????? ?????? ?? ?? ??? ???? ?????? ???????. ???? ?????? ??? ??????? ???????? ???? ???? SA ?? DBA ?? ??? ????? ???????? ??? ???? ?? ???? viable ??? ???????? ??? ?????????? ????????? ?????? ?? ?????.

???????

???? ???????: 169039 - ????? ??? ??????: 20/?????/1424 - ??????: 3.0
????? ???
  • Microsoft SQL Server 4.21a Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbmt kbenv kbhowto kbusage KB169039 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????169039
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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