BUG: ???????? ????? ????????? ??? ????????? ??? ????? ????? ??????? ?? LDF

?????? ????????? ?????? ?????????
???? ???????: 257855 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???: 57670 (sqlbug_70)
????? ???? | ?? ????

?? ??? ??????

???????

??? ?? ????? ??? ?????? ????? (LDF) ?????? ?????? ????? ??? ??????? SQL Server (??? ???? ??????? ??? ??? ????? ????? ????? ?? ???) ? ????? SQL Server 7.0 ?? ??? ??????? ????? ????? ????? LDF ???????? ?????? ?? ???? ????? ????????.

???? ??? ????? ????????? ?? ??? LDF ?????? ??????? ??? ??????? ????? ?????? ?? ????? ????????? ??? ????????. ????? ??????? ?????? ?????? ????? ???? ????? ??? ????? ??? ????? ???? ??? ????? ?????????? ??? ????????.

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

??? ??? ?????? ??? ????? ????????? ??? ???? ??? ????? ?????? ?????? ??????? ??? ????? ???????? ??? ???????? ???????:
????: ????? 3155 ? ????? 16 ???? 1? ????? 1
?? ???? ?????? ????? ????????? ??? ???? ?? ???? ?? ????? ??? ???????? ?? ????? ?? ????? ???????? ??? ????? ?????? ????? ?????????.

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

???? ??????

??????? ?????? ??? ??? ??????? ?? ????? ??? ???:
  • ???? ?? ?? ??????? LDF ?? ??? ???? ?? ????? ??????.

    - ?? -
  • ????? ????? ??????? ????? ?????? ????? ??? ????? ????? ????????? ??? ???????? ???.

?????

???? Microsoft ??? ???? ????? ?? SQL Server 7.0.

??????? ????

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

  1. ?????? ???????? ??????? ?????? ????? ?????? ????? ?????? ?????? ????? ????? ???????:
    create database test
    go
    
    use test
    go
    create table t (c int)
    go
    insert into t values (1)
    go
    
    backup database test to disk='c:\test_dump.bak' WITH INIT
    go
    insert into t values (2)
    go
    backup log test to disk='c:\test_dump.bak' WITH NOINIT
    go
    
    insert into t values (3)
    go
    
    use master
  2. ???? ??????? ??????? ?????? SQL Server ????? ??? LDF ???? ?????? ???????? ??? ??? ???????:
    1. ???? ?? ?? ?? ?????? ???? ?????? ??????.
    2. ????? ???? SQL Server.
    3. ????? ????? ????? test_log.ldf.
    4. ??? ????? ???? SQL Server.
  3. ???? ?? ????? ?????? ?? ??????? ?? ??? ????? SQL Server ??????? ??? ????? ??? LDF ????:
    c:\MSSQL7\data\test_log.LDF ????? ??? ????? - ??? ???? ??? ?????.
    ?????? ????? ????? ??? ????? ??????? ?? ??? ?????? ????? ????????.
    ...
    ???? ??? ??? f:\MSSQL7\data\test_log.LDF ???????.
  4. ?????? ???????? ??????? ??????? ????? ????? ?????????:
    use test
    go
    insert into t values (4)
    go
    backup log test to disk='c:\test_dump.bak' WITH NOINIT
    go


  5. ?????? ???????? ??????? ??????? ??????? ????? ?????????? ??? ????? ?????? ????? ???? testrestore:
    RESTORE DATABASE testrestore
       FROM disk='c:\test_dump.bak'
       WITH NORECOVERY, 
       MOVE 'test' TO 'c:\testrestore.mdf', 
       MOVE 'test_log' TO 'c:\testrestore.ldf'
    RESTORE LOG testrestore
       FROM disk='c:\test_dump.bak'
       WITH NORECOVERY,FILE = 2
    RESTORE LOG testrestore
       FROM disk='c:\test_dump.bak'
       WITH FILE = 3, RECOVERY
?? ??? ???????? ????? ????? ????? ???????:
????: ????? 3155 ? ????? 16 ???? 1? ????? 1
?? ???? ?????? ????? ????????? ??? ???? ?? ???? ?? ????? ??? ???????? ?? ????? ?? ????? ???????? ??? ????? ?????? ????? ?????????.

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

???????

???? ???????: 257855 - ????? ??? ??????: 23/???? ?????/1435 - ??????: 1.2
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbbug kbpending KB257855 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????257855

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