INFO: ????? ????? ????? ??????? ?????? Dirty ?????? ??? ?????

?????? ????????? ?????? ?????????
???? ???????: 78363 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

?????? ??????? ????? SQL Server ????? ??????? ???? ?? ??????? ??????? ?/?? ????? ?????? ("???"). ???? ???? ?????? ??? ????? ??? ??????? ??? ????? ?????? ????? ????????? ??? ??? ???? ?? ????? ?????? ????????.

??????? ????

???? ??? SQL Server ????? ?? ????? ??????? ?????? ??? ????? ??????? ???????:
  1. ????? ??? ????? ???? ??????.

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

    1. ???? ????? ???????? ?? ????? ?????? (SA) ???? ????? ??? ???? ???? ?? ?? ???.
    2. ??? ????? ??? ????? ????? ?????? "??" ????? ???????? ?????? ?????? ?? ????? ????? ?????? ???? ???? ?? ????? ????????.
    3. ??? ????? ???? ?????? ?? ?? ????? ???????? ??? ?????? ????? ????????? ?? ??????? ????? ????????. ???? ????? ??? ?????? ?????? ??????? ??????? ?????? sp_dboption ?? ????? ???? "?? chkpt ?????????" ??? true.
    4. ??? ??? ????? ???? ?????? ???????? ??? ???? ?????? ?????? ?? ????? ??? ???? ???? ?? ????? ????????? ???? ??? ??? ???? ??????. ??? ????? ?? ?? ???? ?????? ?????? ?? ????? ????? ??? ??? ????? ???????? ??????? ????? ???? ??? ??? ????? ?????? ???? ?????? ???? ???? ?????? ????? ?? ????????? ? ?????? ???? ??? ????? ?????? ?????? ?????????. ?????? ??? ??? ??? "trunc. ??? ?? ????? ???? ????? ?????? chkpt."???????? sp_dboption ? ????? ???? ?????? ?? ??? ??? ???? ???? ?????? ?????? ?? ????? ????? (??? ??? ????? ????????).
    5. ??? ????? ???? ?????? ????? SA ?????? ????? SHUTDOWN.
  2. ????? ???? ??????? ??? ????? ??????? ?????? ?? ???? ?????.

    ??? ??? SQL Server ???? ???? ???? ??? ?????? ?? ????? ??????? ?????? ???? ?? ?????? ???? ??? ?? ????? ???? ????? ??????? ?????? ". ????? ????? ?? ???????? ??? ??????? ? ??? ??? ?????? ?? ?????? ?????? ?????? ??? ?????.
  3. ?? ????? ?????? ????? ????? ????? ?? SELECT INTO.

    ??? ??????? BCP ????? (??????? ??? ?????) ?? ??? ????? ???? ???????? SELECT INTO ?? ??? ????? ?????? ??????? ??????. ?????? ?????? ???? ?? ???? ?? ??? ?? ????? ??????? ??????. ??? ??? ???? ??????? ??? ????? ???? ????? ???????? ?? ????? ???? ?? ????? ????? SQL Server ???? ???? ??????, ??? ????? ????? ????? BCP ?? SELECT INTO.
  4. ??? ??? ????? ????? ??? ?????? ??????.

    ??? ?????? ?????? ??? ?? COMMIT ?? ????? ? ??? ??? ????? ??? ??? ?????.
  5. ??? ????? ???? ? ??? ??? ?????? ??????? ?????? ?????? ??? ?????.
  6. ???? "????? ?????? ?????" ???? ??????? ??? ?????.

    ??? ????? ????? ?????? ?????? ????? "????? ????? ??????" ? ??? ????? ???? ??????? ?? ??????? ?????? ??? ?????. ???????? ??? ???? ??? ????? ?? ????? ???????? ??? ???????? ??????? ????? ????? ???? ??? ?????. ??? ???? ??????? ??? ??? ???? ?????? ??? ????? ?? ????? ?????? 4 ???????? ?? ????? ?????? 10 ???????? ???????? 6 ???????? ?? ????? ???? ???? ??? ?????? ? ???????? ??? ?????.
  7. ???? "?????? ???????" ????? ??? ????? ???.

    ??? ????? ????? ???? ????? Lazywriter ? ??? Microsoft SQL Server ??????? 4.21. ???? ????? Lazywriter ???????? ??? ??????? ??????? ????? ??? ??? ??????? ??????? ????? ???????? ?? ?????? ????? ???? ?? ??? ??????? ??????? ????? ????? ??? ????? 6 ??????? 5 % ????? ??????. ??? ????? ??? ?????? ???? ????? ????? ?? ?????? ??? ??????? ??????? ?? ????? ??????? ??????. ??? ????? ???? ????????? ??? % 3 ?? ??????? ??????? ?? ????? ??????? ?????? ????????. ?????? ??? ???? ?? ????????? ???? ??????? ??????? Microsoft SQL Server ??????? 4.21 (\sql\install\readme.txt).
????? ???? SQL ????? ???? ? ???? ??????? ??? ????? ?????????? ? ??? ?? ???? ?? ??? ?????? Microsoft SQL Server Always-On ??????? ???? ??????. ??????????? ?? ????????? ??? ??????? ??????? ???? ????? ?????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
967576??????? ???????/??????? ???? ????? ?????? ???? Microsoft SQL

???????

???? ???????: 78363 - ????? ??? ??????: 05/????/1426 - ??????: 3.2
????? ???
  • Microsoft SQL Server 4.21a Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt kbinfo KB78363 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????78363
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? 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