????? ???????? ???????? ??????? ?????? ?? ??? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 910378 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

????? ???

??? ?????? ??????? ????? ???????? ???????? ?? ??? Microsoft SQL Server 2005 Enterprise Edition. ????? ??? ?????? ?????? ??????? "????? ?????? ?????? ????? ???????" ???? ???? ??? ?? ??????? ???????? ?? "??? SQL Server ???????".

??????? ????

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

???? ?? ????? ???????? ???????? ??????? ????? ????? ?????? ?????? ??????? ??? ??? ??? ?????? ?????? ??? ???? ????? ????? ????? (SAN). ????? ?????? ?????? ?? ????? ?????? ??????? ??? ?? ?????? ?? ????? ?????? ??????? ?? ???? ??? ????????? ???? ??? ?????? ???????? ??????. ??? ???? ??????? ??? ????? ?????? ?????? ??????? ? ??? ?? ???? ????? ?????? ?????? ??? ???? ?? ???? ???? ??????? ??? ?????. ????? ??????? ?? ????? ??????? ??? ??????? ??? ??????? ????? ?????? ???????? ?? ?????? ??????? ?? ??????? ?? ????? ????????. ????? ????? ??????? ??? ???????? ????? ???????.

?????

???? ????? ???????? ???????? ??????? ??????? ???????:
  • ???? ????? ??? ????? ????? ????? ???????? ????? ???????? ?? ???? ??????? ?????? ??????. ????? ?????? ?????? ??????? ????? ???????? ??????? marts ?????? ??????? ??? ?? warehouses ???????? ??? ?????? ?????? ?????? ???????? ?????? ??? ????????? ??????? ?? ???????? SQL Server 2005 ??????? Services.
  • ???? ??? ??? ?????. ?????? ?? ???? ????? ???????? ?????? ?? tempdb CPU ??????.
  • ???? ??? ????? ??? ?????? ?? ???? ?????? ??????? ??? ?? ????? ???? ?????? ?????? ?????. ??? ???? ??????? ??????? ???? ?????? ????? ????.

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

????

???? ????? ?????? ?????? ??????? ?????? ???????:
  • ??? ?? ???? ????? ???????? ??? ???? ????? ??????? ???.
  • ???? ?????? ??? ????? ???????? ??? SAN.
  • ??? ?????? ??????? ????? ???????? ???????? ?? Microsoft Windows Server 2003 Service Pack 1 (SP1) ?? ????? ???? ?? ???? ??????? Windows Server 2003 ???.

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

??? ??????? ????? ?????? ?????? ??????? ????? ?????? ?????? ??? ????? ???? ????? ????? ????:
  • ????? ???????: ????? ??????? ?? ????? ?????? ???????? ???? ????? ???????. ??? ?? ??? ????? ????? ?????? ?????? ? ????? ???? ????? ???????? ??? ?????? ??????? ??????? ??? ???? ?????/?????. ????? ???? ???? ????? ?? ???? ?????/????? ???? ????? ???? ??????? ??? ???? ???? ???. ?? ???? ????? ???? ??????? ??? ???? ?? ????, ??? ???? ??? ???? ???????. ??????? ?? ???? ????? ???????? ???????? ???? ????? ???? ???????? ??????? ?? ??? SQL Server 2005 ??? ???????? ?? ????? ????????. ??? ??? ????? ????? ???????? ??????? ????? ???? ??????? ??????? ??? ??? ?? ????? ????? ????.
  • ????? ?????: ????? ????? ???? ??? ????? ???????. ????? ????? ????? ????? ???????? ?????? ?????? ?????? ???????. ??? ????? ??????? ????? ??? ?? ?? ??????? ?? ?????? ???? ????. ?????? ????? ?????? ???????? ??? ????? ?????? ?????? ??????? ????? ??????? ????? ??????? ??? ???????? ??? ???? ?????? ??? SAN. ??? ???? ??? ??????? ?????? ?? ????? ?? ???? ????? ??? ??????? ???, ??????? ????? ????? ?????? ???????? ??? ???? ?? SQL Server. ???? ????? ????? ?????? ???????? ??? ???? ?? SQL Server ???? ???? ??????. ??? ?? ???? ????? ???????? ??????? ???, ????? ????? ???????? ????? ??? ??????? ???. ?? ??? ???????? ???? ????? ?????? ???????? ????? ?????? ?????? ??????? ?????? ?? ??? ??????? ???????? ???? ????????.

    ?????? ??? ??? ?????? ???? ????? ?????? ???? ??? ????? ????? ?????? ???????? ??? ???? ?????? ??? ????? ?????? ????? ???????. ????? ?? ?????????? ???? ??? "????? ???? ????? ?????? ?????? ???????".
  • ????? ???: ??????? ??????? ?? ??????? ???. ????? ?? ????? ?????? ???????? ?????? ???? ?? ???? ??. ??? ?? ??? ????? ????? ???????? ???????? ??????? ??????? ??????. ????? ??? ????? ????? ????? ?????? ?????? ???? ?? ???? ??? ?? ???? ??? ????? ?????? ?????? ???????. ??? ?? ????? ??? ????? ?????? ?????? ?????? ?????? ??? ???? ?????? ????, ??? ????? ????? ??? ??? ??? ??????. ????? ??? ?? ??? ????? ????? ?????? ?????? ? ??? ?? ??? ??? ?? ???? ?????? ??????. ???? ??????? ??? ????? ????? ????? ???????? ????? ????? ????? ????????? ??????? ????? ???????? ?? ???? ?????? ??????. ?? ?? ???? ?????? ????? ????? ???????? ???? ??? ?? ???? ??? ??? ????? ???????? ?? ?? ????. ????? ????? ???????? ?? ????? ????? ???? ??????? ?? ?? ???? ??????. ??? ????? ????? ??? ???? ????? ???????? ??? ??? SAN.
?????? ?????? ????? ?????? ??????? ???? ??????? ????? ??????? ??? ????? ????? ???????? ??????? ????. ????? ??? ????? ???? ????? ???????? ????? ?? ???? ?????? ????? ????????, ????? ????? ???? ??????? ?????? ??? ???? ????? ?????? ?? ????? ??????? ???? ?? ????? ?????? ????????. ????? ?? ?????????? ???? ??? "????? ???? ????? ?????? ?????? ???????".

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

??? ?????? ????? ?????? ?????? ??????? ???? SAN ??? ?? ?????? ???? ???? ???? ????.

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

?? ????? ??????? ??????? ???? ????? ????? ???????? ?? ????? ???????. ????? ??????? ??????? ??? ??????? ????? ????? ??. ????? ??????? ????? ???????? ???????? ??????? ???????? ???????:
  • ????? ???????? mart ????????: ???? ??????? ????? ?????? ?????? ??????? ????? ?????? mart ??????. ????? ?????? mart ?????? ??? ??????? ???? ???? ?? ??????? ?????? ???????? ??????? ????????. ?????? ????? ???????? mart ???????? ????? ????? ???????? ?? ?? ???????? ?? ????? ????.
  • ???????? ?? ????? ?????? ????? ???????: ????? ?? ???? ????? ?? ????? ?????? ?????? ????? ???????? ???? ??? ????? ????? ?? ? ???? ????? ????? ???????? ???? ????. ???? ???? ????? ????? ???????? "? ?? ?????? ???? ???????? ????? ?? ????? ?????? ??????? ?? ?? ??????? ????? ????????? ?????? ???????? ??? ???? ??????? ?? ????? ??????? ????????.

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

??? ?? ???? ????? ?????? ?????? ??????? ??? ???? ????? ??????? ??? ???? ???? ?????? ????? ??? SAN. ??? ?? ???? ?????? ???????? ???????:
  • Windows Server 2003 ?????? ????? ?????? SP1 ?? ????? ???? ?? ???? ??????? Windows Server 2003
  • SQL Server 2005 Enterprise Edition ?? ????? ???? ?? SQL Server 2005
?????? supportability, ?? ???????? ????? ??????? ????? ?????? ?????? ??????? ????? ?? ??? ?????? ?????? ??????. ??? ???? ?? ??? SQL Server 2005 ????? ??????? ????????? ???? ???? ?????? ??? ????? ?????? ?????? ???????. ???? ???? ??? ????? ?? ???? ?????? ??? ???? ????? ??????. ??? ???? ???? ??? ?????? ?????? ???????? ??? ???? ?????? ?????.

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

?????? ?? ?? ?????? ?????? ?? ????? ????? ???????? ???????? ??????? ???? ?????? ??? ?????????:
  • ???? ?? ????? ???????? ???????? ????? ?????? ?????? ????? ??? ????? ??????? ???????. ??? ????? ???? ????? ????? ??? ?????? ???? ???????? ???? ??? ????? ???????? ???????? ??????? ?? ????? ??????. ??? ???? ??????? ??? ??? ?????? ???? ????? ??????? ?? ???? Windows ?? SQL Server 2005 ??? ?? ??? ???????? ???????? ????? ??? ??? ??????? ??????? ?? ???? ??????? ??? ???? ?????? ????????.

    ?????? ???? ????? ????? ????? ????? ?????? ?????? ???????? ????? ?????? ????? ?????? ?? ????? ???????.
  • ??? ?????? ??????? ????? ???????? ???????? ??? ??? ??? ???? ??????? ?????? ?????? ??? ?????? ??? ?????? SQL Server 2005 Enterprise Edition. ?? SQL Server 2005 ??? ???? ????. ??? ????? ?? ???? ???? ?? ???? ??????? ????? ?????? ?????? ??????? ????? ?? ??? ?????? ?????? ?????? ??? ????? ?????? ??????.
  • ??? ????? ???????? ?? ????? ?????? ??????? ???? ??? ??? ????? ?????, ??? ??????? ??? ????? ?? ??????? ?? ????? ???????. ??? ???????? ???? ????? ????? ?????? ???????? ??? ??????? ??? ???? ???????? ????? ????? ?????? ?? ?? ????? ???????? ??? ???? ????? ??????.
  • ?????? ????? ????? ?? ????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ????? ?????? ???????? ??? ????? ?????? ???????. ????? ??? ???????? ??? ??? ??? ???? ??????? ?? ????? ???????? ???? ?????? ??? ????? ??????. ??? ???? ??????? ?? ???? ??? E:\SQLdata ????? ?????? ??????? ??????? E ??? ?? ??? ???? ????? ???? ????? ??????? ? ??? ??? ??????. ???????? ??? ???? ?????? \SQLdata ????? ????? ?????? ???????? ??? ??? ??????. ??? ???? ???? ?????? ???????? ??? ???? ????? ??? ?????? ????? ?? ????????. ??? ???? ???? ??????? ???????? ?????? ??? ???? ????? ??????? ?? ???? ??????? ??????? ? ?? ????? ??? ????? ??????? ???????:
    • ????? ????? ?????? ???????? ?? ???? ??????? ????? ??????? ?????? ?????? ??? ?? ???? ??? ????? RESTORE ????? ?????? ???? WITH ??? ???? ?????? ?????? ?????? ????????.
    • ???? ????? ?????? ???????? ??? ???? ?? ????? ?????? ??????? ??? ??? ???? FOR ????? ???? "????? ????? ??????" ?? ???. ??? ????? ????? ???? FOR ????? ?????? ??????? ??? ????? ????? ?????? ????????. ??? ????? ???? ??????.

      ?????? ??????? ???? ??????? ??? ??? ???? ??????? ??? ?? ???? ??? ????? ???? ????? ?????? ??? ?????? ????????. ?????? ??? ??????? ?? ????? ???? ??????? ??? ?????? ??????.
  • ??? ?? ???? ????? ?????? ???????? ??? ???? ????? ??????? ??? ???? ???? ?????? ????? ??? SAN ?? ???? ?????? ????????:
    • ??? ????? ???? ????? ???????? ??? ???? ?????? ???? ?? ?? ??? ????? ???? ??????? ???????? ???? ???? ???? ???? ?????? ??? ????? ????????. ?????? ????? ???? DIR <drive-letter>: \ <database-directory> ?? ???? ???????? ??? <drive-letter> ??? ????? ??? ???????? ???? ??????? ? <database-directory> ????? ???? ????? ???????? ????? ???????? ??? ???? ???????. ????? ??? ???????? ?? ?? ???? ???????? ?????? ?? ???? ??? ??????? ??? ????.
    • ???? ?? ????? ????? ?????? ???????? ??????? ???, ???? ????? ??? ??? ???? ???????. ??? ???? ????? ?? ????? ??? ?? ??? ??? ?? ???? ??? ???? ???????. ??? ?? ???? ???????? ??? ???? ??????? ??????? ???.

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

????? 1: ????? ???????

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

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

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

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

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

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

?????? ????? ?????? ?????? ???? ?? ???? ??? ???? ??????? ??????? ??? ???? ???????:
  1. ??????? ??????? ???????? ????? ??????? unmask ????? ??????? ???????? (LUNs) ???? ?????? ?? ????? ????? ????????. ????? ??? ??????? ??? ????? ??????? ?? ?????? ??? ???? ???????.
  2. ????? ???? ??????? ???????? ?? ?? ??? ????? ??? ???????/???????. ???????? ?????? ???????? Diskpart ???????? ???? ??????? ????? ???? ???????, ???? ??????? ??????? ?? ???? ???????: DiskPart
    ???? > ??? ???? ??????? =<drive-number>
    ???? > ????? ??? =<drive-letter>
    ???? > ????? ??????? ??? ???
    ???? > ?????

    ?? ??? ??????? <drive-number> ?? ??? ???? ??????? ???? ?? ??????? ?????? Windows <drive-letter> ?? ??? ???? ?? ?????? ??? ???? ????? ????????.
  3. ??? ??? ???? ?????? ????? ?????? ?????? ?????? ???? ??????? ???????:
    1. ????? ????? ???????? ???? ????. ?????? ?? ???? ??? ???? ???? ???????. ????? CREATE
      CREATE DATABASE <database_name> ON <filespec_list>
         FOR ATTACH
      
    2. ????? ????? ???????? ???????/??????? ?????? ???????? ????? SQL ???????? ???????.
      ALTER DATABASE <database_name> SET READ_WRITE
      ?????? ??? ???? ?? ?????????? ???? "??? SQL Server 2005 ???????".
  4. ????? ????? ????????.

    ?????? ????? ?????? ?????? ???? ???? ????? ???????? ??????? ?? ????? ????? ????? ???????? ?? ?????? ???? ??? ????? ????? ????? ????????. ??????? ???? ????? ???????? ???????? ??? ???????? ??? ???????? ???? ??? ??????? ?? ??? SQL Server 2005 ???? ???????? ?? ????? ????????. ????? ?? ?????????? ???? ??? "??? ????? ?? ????? ????? ??????".

    ?????? ?? ??????? ?? ????? ????????, ?? ???????? ????? ??? ?????? ?? ???? ??? ??????? ????????? ? ?????????. ?????? ??? ??????? ??????? ALTER ????? ??????.
  5. ????? ????? ???????? ??????? ??? ???????? ????? SQL ???????? ???????.
    ALTER DATABASE <database_name> SET READ_ONLY
  6. ??? ????? ???????? ?????? ??????? SQL ???????? ?????? ???????.
    sp_detach_db @dbname='<database_name>'
    ?? ??? ??????? <database_name> ?? ??? ????? ????????.
  7. ?? ????? ???? ??????? ??????? ??? ?? ????? ????? ???? ??????? ?? ???? ???????. ???????? ?????? ???????? Diskpart ???????? ???? ??????? ?????? ????? ???? ??????? ????? ??????? ??????? ?? ???? ???????.
    DiskPart
    DISKPART> select volume=<drive-number>
    DISKPART> attribute set readonly
    DISKPART> remove
    
    ?? ??? ??????? <drive-number> ?? ??? ???? ??????? ???? ?? ??????? ?????? Windows <drive-letter> ?? ??? ???? ?? ?????? ??? ???? ????? ????????.
  8. ??????? ??????? ???????? ????? ??????? ???? LUNs ?????? ?? ????? ????? ????????. ???? ??? ??????? ??? ????? ??????? ??? ????? ?????? ??? ???? ???????.
????? ????? ?????? ???????? ???? ??? ?????? ??? ????? ?????? ?????? ???????. ????? ?? ?????????? ???? ??? "????? ????? ?????? ?????? ???????".

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

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

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

      ?????? ????? ????? ????? ????? ?????? ???????? ?? SQL Server ????? ????????? / ??????? ???? ??? ??? ???? ?? ????? ??? ????? ??? ?????.
  • ????? ????????? ??????????: ????? ??????? ???? ???????? ?? ????? ?????? ??????? ??? ???? ????? ????????. ?????? ????? ?? ???????? ???? ???????? ????? ?? ????? ?????? ??? ???? ????? ???????? ????????:
    • ?? ???? ??????? ??? ??? ???? ??????? ????? ???? ??????? ???????? ??? ???? ??? ?? ?? ?????? ??? ???? ???? ??????? ????? ????????.
    • ???? ????? ???????? ?????? ??? ???? ????? ??????? ?? ???? ??????? ??????? ? ??? ?? ???? ??? ????? RESTORE ????? ?????? ???? WITH ??? ????? ??? ???? ????? ???? ????? ???????? ?? ???? ????? ?????? ??? ?????????.
  • ??? ????? ?????? ??????? ??? ???? ????? ????????: ??? ????? ?????? ??? ????? ?????? ?? ??????? ?? ??? ?? ????? ????? "????? ????? ????????" ???? "? ??? ?? ???? ????? ???????? ??? ?????. ??? ??? ????? ???????? ????? ????? ???????? ????? ?????. ??? ????? ?? ???? ????? "????? ????? ????????" ???? ????? ?????. ????? ????? SMO ??? ????? ???????? ??? ????? ?? ?? ??? ????? ???????? ??? ??????. ??? ????? ?? ?? ????? SMO ??????? ???? ?? ??? ????????? ????? ????? ????? ????? SMO ??????? ???? ?????? ????????.
????? ?? ????????? ??? ???? ????????? ???? ???????? ???? "??? SQL Server 2005 ???????".

????? ???? ????? ????? ?????? ???????? ? ??? ?? ???? ?????? ????? ???????. ????? ?? ?????????? ???? "????? 1: ????? ???????" ??????.

??????? ???????: ????? ?????

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

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

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

?? ??? ???????, ??? ??? ????? ?????? ??????? ???????:
  1. ??????? ??????? ???????? ????? ??????? unmask LUNs ?????? ?? ????? ????? ????????. ????? ??? ??????? ??? ????? ??????? ?????? ??? ??????? ?? ?? ???? ????????.
  2. ??? ?? ???? ???????? ????? ???? ??????? ???? ?????? ?? ??? ???? ??????.

    ?????? ?????? ????? ????? ?? ????? ????? ?????? ?????? ?? ???????? ????? ???? ??????? ???????? ??? ????? ???????? ??? ??? ???? ??????? ????? ????? ???????. ??? ???? ??????? ?? ???? ??? ???? ??????? E ??? ???? ??????? ????? ?????? ??????? ???? ????? ???????? ??? ????? ???? ??????? ??? ???? ??????? E ??? ?? ???? ???????? ??? ??? ??????.

    ???????? ?????? ???????? Diskpart ???????? ???? ??????? ????? ???? ???????, ???? ??????? ??????? ?? ???? ???????.
    DiskPart
    DISKPART> select volume=<drive-number>
    DISKPART> assign letter=<drive-letter>
    DISKPART> exit
    
    ?? ??? ??????? <drive-number> ?? ??? ???? ??????? ???? ?? ??????? ?????? Windows <drive-letter> ?? ????? ???? ???? ??????? ???? ????? ???????? ??? ???? ????????.

    ?????? ??? ?? ???? ???? ??????? ???????? ??????? ???. ?? ???????? ?? ???? ???? ??? ????? ??????? ??? ??? ????? ????? ???? ??????? ?? ???? ???????. ??? ?? ??? ??? ????? ???? ??????? ??????? ??? ????? ???? ??????? ??????? ??? ??? ????? ???? ??????? ??? ?????? ????? ????????. ????? ?? ?????????? ???? "????? 1: ????? ???????" ??????.

    ??????? ???? ??? ?????? ?? ?? ???? ??????? ?????? ????? ????? ??????? ??? ??? SAN ??? ????? ???? ????? ????? ??? ???? ????????. ????? ?? ?????????? ???? ??? "???? ?? ??? ?????? ??????? ?????? ?????? ??????".
  3. ????? ????? ???????? ??? ???? ?????? ???????? ?? ???????? ??? ?? ???? ????????. ????? ?? ?????????? ???? "??? SQL Server 2005 ???????".
????? ?????? ???????? ????? ???? ??? ????? ?????? ?????? ??????? ?? ?????? ???????????.

??????? 3: ????? ???

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

???? ???? ??????? ?????? ?? ????? ?????? ???????? ?????? ???? ?? ???? ?? ??? ??? ?? ???? ????? ???????? ??? ????? ?????? ???????. ????? ????? ????? ????? ?????? ?????? ???? ?? ???? ??? ?? ???? ??? ????? ?????? ?????? ??????? ????? ???. ??? ??????? ???? ??????? ??????? ? ???????? ??????? ?????? ??? ????? ?????? ??????. ??? ?? ????? ??? ????? ?????? ?????? ?????? ?????? ??? ???? ?????? ????, ??? ????? ????? ??? ??? ??? ??????.

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

?? ??? ???????, ??? ??? ????? ?????? ??????? ??????? ??? ?? ???? ????????:
  1. ????? ??????????? ??????? ??? ????? ???????? ?? ???? ????? ????????? ?????? ????? ? ??? ??? ??????.
  2. ??? ????? ???????? ?? ?? ???? ?????? ??????? ???????? sp_detach_db @ dbname = '<database_name>' ?????.

    ?? ??? ??????? <database_name> ?? ??? ????? ????????. ?????? ??? ???? ?? ????????? ??? ????? sp_detach_db ???? "??? SQL Server 2005 ???????".
  3. ??? ?? ???? ???????? ????? ????? ???? ????? ????????. ?????? ????? ???? ??????? ???????? ?????? ???????? Diskpart ???????? ???? ??????? ? ???? ??????? ??????? ?? ???? ???????.
    DiskPart
    DISKPART> select volume <drive-number>
    DISKPART> remove
    
    ?? ??? ??????? <drive-letter> ?? ??? ??????? ??? ???? ????? ????????.
  4. ??????? ??????? ???????? ????? ??????? ???? LUNs ?????? ?? ????? ????? ????????. ???? ??? ??????? ??? ????? ??????? ??? ????? ?????? ??? ??????? ?? ?? ???? ????????.

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

??? ??????? ????? ????? ?????? ????? ??? ?????? ??????? ????? ????? ????????. ??? ????? ???? ??????? ????? ??????? ???????? ?? ?????? ?????? ??:
  • ?? ???????? ????????? ??? ??????? ?????? ??? ?????.
  • ??? ???? ????? ??????? ??? ???? ???? ?????.
???????? ??? ??????? ???? ??? ????????, ????? ?? ???? ????? ????? ????? ??? ??? ?? ???? ????????. ????? ????? ????? ??? ?????? ???????:
  • ?????? ????? ????????? ??? ??? ???? ????????: ??? ???????? ??? ???? ????????? ??? ?????? ??? ????? ????? ??? ???? ????? ?????? I/O ??????? ??? ???? ????? ????????. ?? ??? ?? ???? ?????? ???????? ???????? ??? ????? ???????? ??? ??? ????? ???? ????????? ???????. ????? ?? ??? ????? ???????? ?? ???? ?????? ??????, ???? ????? ????? ???? ????? ????????.
  • ????? ????? ???????? ????? ???? ???? ?????: ?? ??? ??????? ??? ?????? ??? ?? ???? ??? ??? ????? ???????? ??? ?? ???? ?????? ?? ??? ????? ???? ???? ???? ????? ??. ??? ??? ?? ????????? ?? ????????? ???? ??? ????? ????? ???? ?????. ???? ???????? ??? ??? ??????? ??? ????? ????? ??? ???????????. ??? ????? ??????????? ????? ??? ????? ???????? ?? ?? ???? ?????? ?????? ????? ????? ???? ??????? ???????? ?? ?? ???? ????????.
??? ??? ?????? ?? ?????? ??????? ?????? ???????. ????? ?? ???? ??? ??? ?????? ????? ????? ???????? ??? ????? ???????? ???? ??? ???? ? ????? ???? ????? ????? ????? ????? ??????? ????. ????? ?? ?????????? ???? ??? "????? ???? ????? ?????? ?????? ???????".

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

?????? ????? ?????? ??????? ???? ??????? ????? ??????? ??? ????? ????? ????????. ????? ??? ????? ???? ????? ???????? ????? ?? ???? ?????? ????? ????????, ????? ????? ???? ??????? ?????? ??? ???? ????? ?? ????? ????? ???? ?? ????? ?????? ????????.

??? ??? ?????? ????? ?????? ???????? ??? ???? ????? ?????? ???? ?? ?? ???????? ???????? ???????:
  • ??? ??? ???? ?? ?? ???? ???? ????? ???????? ???????? ?????? ????? ?????? ??????? ??? ??? ?????? ??????? ?? ???? ?????? ?????? ??? ????? ?????? ??????? ??? ?? ????.
  • ??? ??? ???? ??? ????? ???? ????? ?????? ??? ?????? ?????? ?????? ??? ????? ????? ?????? ???????? "? ????? ????? ????? ?????? ?? ????? ?????? ????????. ????? ???? ??????? ??? ???? ????? ???? ?? ?? ???.

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

??? ??? ?????? ??? ??????????? ????? ????? ????? ?????? ?????? ??????? ? ???????? ??? ??????? ????? ????? ??:
  • ???? ??? ???????? ???? ???????? ???????? ?? ????????.
  • ??? ????? ??????? ??? ???? ???? ?????. ???? ???? ??? ????? ???? ?? ???????? ????????? ??? ??????? ??????.
??? ?????? ????? ???????? ??? ???? ?????? ???????? ????? ????? ?????? ???????? ??? ????? ??? ??????? ???? ?? ???? ??? ?? ????? ???????? "?" ????? ????? ????? ????.

??????? ???? ??????? ??? ???? ???????? ?????? ?????? ? ????? ???? ??????? ??? ???? ???? ????? ???? ??????? ???????:
  1. ???????? ??????? ? ???? ?? ????? ?? ??? ??????? ???? ????? ????? ??? ???? ???????? ??????? ??? ??? ?? ?????? ????????. ?? ???? ???? ??? ?? ???? ???? ????????? ?? ??????? ????? ?????? ??? ????? ???????.
  2. ??? ????? ????? ???? ??????? ???????? ????? ?? ???? ?????? ??????, ????? ????? ?? ????? ?????? ????????. ??? ?? ???? ???????? ????? ???? ????? ???? ????? ??? ????? ???? ?? ????? ?????? ????????. ?? ?????? ??? ??????? ?????? ???? ?????? ????????. ????? ?? ??? ????? ????? ???????? ??? ???? ??? "? ???? ????? ????? ????? ????????? ???? ??????.

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

????? ????? ????? ?????? ????? ????? ?????? ???????? ??? ???? ???? ???????? ??? ????? ??????? ?? ????? ?????? ???? ??????? ???? ???? ??? ?????? ????? ???. ????? ? ?? ?? ??????? ???? ?? ???? ??? ? ????? ????? ????? ?????? ????? ?? ??? ?????. ???????? ??? ??????? ????? ????? ?? ???? ?? ???? ????? ?????? ?? ???? ???? ????? ?? ???? ?? ???? ??????? ?????? open-ended ?????? ?????? ????????? ??????? ????????.

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

?? ??? ???????????? ???? ????? ?????? ????? ????? ???????? ?????? ????????? ??????? ????? ????? ?????? ??? ???? ???? ???????? ??? ????? ????? ???????? ??? ???? ???????? ???. ????? ??? ???????????? ??????? ????? ???????:
  • ?? ???? ?? ???????? ??? ?????? ?????? ????????. ??? ???? ????? ?????? ??? ????? ?????? ???????? ???? ?? ???? ??? ?? ????? ????? ?????? ????????.
  • ???? ???? ???? ??? ????? ?????? ??????? ?? ?????? ??????? ????? ?? ????? ??? ?? ???????? ????????? ??? ??????? ??????.
?????? ??? ????? ?? ??????? ??? ?????? ??????? ???? ??????? ??????? ??? ???? ???? ???? ?? ?? ???:
  1. ???????? ??? ???? ????????? ??? ?????? ??? ???? ??? ????? ????? ??? ?????? ????? ?????? I/O ??????? ??? ???? ????? ????????. ??????? ??????? ????? ????? ???? ??????? ??? ???? ???? ? ???????? ????????? ?????? ??? ??? ???? ?????? ??? ?????.
  2. ??? ???????? ?? ???? ????????? ??? ???? ?????? ??? ? ??? ????? ?????? ????????.
  3. ??? ??? ????? ?????? ?????? ????? ?? ???? ?????? ?????? ????? ????? ?????? ???? ?? ????? ?????? ???????? ??? ???? ??????.
  4. ?????? ???? ?????? ??? ???? ?? ??? ????????? ??????? ????? ????? ????? ?? ????? ????????.

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

?? ??? ???????????? ???? ????? ?????? ????? ????? ???????? ???????? ??? ?????? ???? ????? ???????? ?? ???? ?????? ???? ?? ???? ??? ????? ????? ?????? ??????? ????? ??????????? ??????? ??? ??? ?????? ???????? ???? ????. ???? ??? ?????? ?????? ??? ????? ????? ???????? ??? ???? ???????? ???. ????? ??? ???????????? ??????? ????? ???????:
  • ?? ???? ?? ???????? ??? ?????? ?????? ????????. ??? ???? ????? ?????? ??? ????? ?????? ???????? ???? ?? ???? ??? ?? ????? ????? ?????? ????????.
  • ??? ????? ??????? ?? ???? ???? ?????. ??? ?????? ??????? ????? ???? ?? ???????? ????????? ??? ??????? ??????.
?????? ??? ????? ?? ??????? ??? ?????? ??????? ???? ??????? ??????? ??? ???? ????? ???? ?? ?? ???:
  1. ????? ?????? I/O ??????? ??? ???? ????? ???????? ?? ???????? ???????? ????????? ????? ?????? ??? ???? ???? ??? ??? ????? ?????? ???????? ?????? ??.
  2. ????? ????? ??? ??? ??? ??????. ????? ?? ?????????? ???? ??? "??? ????? ?????? ?????? ???????".
  3. ????? ??????? ??????? ?? ????? ?????? ???????? ?????????? ??????? ??? ????. ????? ?? ?????????? ???? ??? "????? ????? ?????? ????? ??????? ??????".
???? ??? ??????? ?????? ????? ?? ??? ?????? ???? ??????? ?????. ????? ??? ???????????? ??? ????????? ?????? ??????? ????? ????? ??? ??? ?????? ?????? ?????. ??? ???? ????? ???? ???? ????? ?????? ???? ????? ???????? ????????? ??? ??? ??????? ??????? ????? ????? ???? ????? ???? ??????? ??? ???? ????, ??? ????? ????? ??? ?????????. ????? ???????? ????????? ?????? ????? ???? ?????? ??? ??? ????? ????? ?????? ???????? ?????? ?? ?? ????? ????????? ???? ????? ???? ??? ???? ??????.

?????

?????? "??? SQL Server 2005 ???????" ?? ?????? ???? "???? ??????? ?? Microsoft" ??? ????? "??????:
http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en
????? ???? SQL ????? ???? ? ???? ??????? ??? ????? ?????????? ? ??? ?? ???? ?? ??? ?????? Microsoft SQL Server Always-On ??????? ???? ??????. ??????????? ?? ????????? ??? ??????? ??????? ???? ????? ?????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
967576??????? ???????/??????? ???? ????? ?????? ???? Microsoft SQL

???????

???? ???????: 910378 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 2.4
????? ???
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt kbsql2005engine kbtshoot kbinfo KB910378 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????910378

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

 

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