• quote:


    RESTORE LOG test_1c

    FROM disk='D:\ONEC\ONEC.TLF'

    WITH RECOVERY

    -- restore failed:


    The problem comes from last restore log statement. You have to add "FILE = file_number" option to indicate which backup set from 'D:\ONEC\ONEC.TLF' to be restored. You can use RESTORE HEADERONLY to find out. In your case, it should be 5.

    The complete restore statement should be like

    RESTORE LOG test_1c FROM disk='D:\ONEC\ONEC.TLF' WITH FILE = 5, RECOVERY