??? ??????? ?????? nonlogged ???? ?? ?? ??????? ??????? ??? ????? ????????? ?? SQL Server "?" ????? ????????? ??? ????????

?????? ????????? ?????? ?????????
???? ???????: 272093 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

??? ???????? ???? ??? nonlogged ? ???? ?? ?? ??????? ??????? ?? ???? ?? ????? ????? ??? ????? ??? ???????? ?? ????? ??? ??? ???????? ??? ???. ???? ??? ??????? ??????? ??? ??? ???????? ?? ??? ????? ??? ???????? ??????? ????? ????? ????????? ???????? ???????.

?????? SQL Server 7.0 ?????? SQL Server 2000 ????? ??? ????????? ?????. ????? ?? SQL Server 2000 ????? ?????? ?? ??? ???????.

??????? ????

SQL Server 7.0

???????? ??? ??????? nonlogged ?? ????? SQL Server 7.0 ?? ???? ??? ?????? ??? ?????? ????? ????? ??????? ??? ?????? ??? ??? ??? ???????? nonlogged:
  • ???? ???? ????? ????????? ???? ?? ????? ????? ???:
    ????: ????? 4213 ? ????? 16 ???? 1? ????? 1

    ?? ???? "??? ????? ?????????" ??? ????? dbname ??? ?? subjected ??????? nonlogged ???? ??????? ??????. ????? ????? ?????? ???? ?? ???? ????? ????????? ????? ?????????.
    - ? -
    ????: ????? 3013 ? ????? 16 ???? 1? ????? 1

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

    ????? ?????? nonlogged ???? ??? "???? ????":

    • nonlogged bcp
    • ??? ??
    • writetext
    • updatetext
    • ???????? ????? ????? (DTS) ?? ????? ????????? ?????? ?????? ????? ????? ??????.
    ????? ???? ?????? ??????? ??? ????? ???????? ?? ????? ???????? ???????. ???? ?? ??? ????? ???????? ??????? ???? ???? ?? ??? ????????? ?? ???? ??????? ????? ???????? ???????? ?????? ?? ???? ???? ??? ????. ??? ????? ??? ??????? ???? ?? ???? ????? ?????? ??? ???? ??????? ????? ?????????? ??? ????????.

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

    ????? ?????? ???? ??? "???? ??????":

    • ????? ????????? ??? ?????? truncate_only
    • sp_dboption "trunc. ????? ??????? chkpt"????? ??? TRUE ???????

      sp_dboption "trunc. ????? ?????? chkpt ?? ?????? ??? FALSE.
    ??? ???????? ??????? ????? ??? ??? ?? ??? ????????? ??? ????? ????????? ??? ?????????. ??? ?????? ????? ? ??????? ??????? ?????? ????? ????????? ??? ????????? ??? ????? ????? ?????. ?????? SQL Server ?????? ????? ????????? ??? ????????. ??? ????? ?? ???? ??? ?????? ?????????? ??? ???????? ??? ???? ??? ?? ??? ???????. ??? ????? ????? ????? ??????? ??? ?????? ??????? ????? ?????????? ??? ???:

    ????: ????? 4305 ? ????? 16 ???? 1? ????? 1

    ?? ???? ??????? ??? ?????? ????? ????????? ???? ????? ????? ???????? ?? ??? ??????? ??? ??? ?????? ???? ?????. ??? ????? ??????? ???? ??????? ??????? ??? ??????? ??? ?????.
    - ? -
    ????: ????? 3013 ? ????? 16 ???? 1? ????? 1

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

??????? ???? ??? "???? ??????":
  • ?????? ??????
???? ?????? reclaims ????? ????????? ?? ??? ??????. ???? ??? ????????? ????????? deallocation ??????. ????? ???? ?? ??? ????? ??????? ???? ??????. ????? ????????? ??? ???????? ??????? ????? ?? ???? ????????? ?? ??? ??????? ????.

SQL Server 2000 ?? SQL Server 2005

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

?? ???? ????????? ????? ??? ?? ?????? ?????? ????? ????????? ??? ????????? ????? ?? ????? ????? ???????:
????: ????? 4208 ? ????? 16 ???? 1? ????? 1

??? ????? ????? "??? ????? ?????????" ????? ???? ???? ????????? ?????. ??????? "????? ?????? ????? ?????????" ?? ????? ???? ????????? ???????? ALTER ????? ??????.
- ? -
????: ????? 3013 ? ????? 16 ???? 1? ????? 1

??? ???? ????? "??? ????? ?????????" ???? ??? ?????.
?? ???? ????? ???? ?? ??? ????? ????? ?????? ???????? ??????? ???? ????? ????? ????????:
  • ????? ?????? ?????, ??? ?? ??? bcp INSERT ????? ?????.
  • CREATE INDEX ? ??? ?? ??? ??? ????? ????????.
  • ??? ??
  • writetext
  • updatetext
  • DTS ?? ????? ????????? ?????? ?????? ????? ????? ??????.
?????? ?? SQL Server 7.0 SQL Server 2000 ? SQL Server 2005 ?????? ???? ??? ????????? ????????? ??? ??? ??? ???????? ???? ?? ?? ??????? ???????. ????? ????????? ??? ???????? ?????? ??? ??? ????? ????? ????????? ????? ? ????? ?????? ????????? ???????? ??????? ??? ???????? ???????. ????? ???? ??????? ????? ?????????? ??? ??? ??????? ????. ??? ???? ???? ???? ????????? Bulk-Logged ??? ????? ???????? ???? ???? ????????? ??? ????? ???? ???????? ??? ???????? ??? ????? ????????? ??? ????? ??? ??????? ????? ?????. ????????? ?? ????? ????? ??? ?????. ????? ?? ???? ????? ????????? ??? ???? ????? ??? ?????? ????? ????? ????? ????? ?????? ??? ???? ????? ???????? ?? ????? ????????. ?? ???? ??? ??????? ?????? ??? ????? ???????? ??? ????????? ???????? ?? ???? ????? ??? ??????? ?????? ???? ???????? ??????? ?? ??? ?????.

?? SQL Server 2000 ??? SQL Server 2005 ????? ??? ?????? ??? ?????? ???? ?????? ??? ?? ??? ??????? ?? ????????? ???????. ???? Microsoft ???????? ???? ????????? ??????? ????? ?? ???. ??? ??? ?????? ?????? ????????? ?? ????? ?? ????? ????? ????? ??? ????? ?? ?????? ????? ?????????? ??? ???????? ??????? ?????? ??? ????? ????? ??? ?? ???? ?? ?????? ???? ?????? "SQL Server 7.0" ??? ?????? ???? ???????? ????? ??? ????? ?????.

??? ?????? ????????? ??????? ???????? ??? ????? ?????????? ??? ???????? ?? ????? ????? ???????:
????: ????? 4305 ? ????? 16 ???? 1? ????? 1

???? ????? ?? ?????? ????? ????????? ??? ??? LSN LSNnumber ? ????? ???? ?? ??? ????? ????? ????? ????????. ???? ??????? ????? ??? ????? ????? LSN LSNnumber.
- ? -
????: ????? 3013 ? ????? 16 ???? 1? ????? 1

??? ???? ????? RESTORE ??? ???? ??? ?????.
????? ?????? ????? ??????? ?? ????? "SQL Server 7.0" ????? ??? SQL Server 2000.

???????

???? ???????: 272093 - ????? ??? ??????: 05/?? ??????/1426 - ??????: 4.3
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbinfo KB272093 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????272093

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

 

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