• on tuesday we want to restore databse on stand by server,

    we have monday full backup and approx 40 transaction log till 1PM of tuesday

    we run the below query

    Restore database Databasename

    from disk='c:\backup\testbackup.bak'

    with norecovery

    restoration sucssfully till mondy night

    Now, we want to restore multiple trans till 1 pm

    so we run below query

    Restore log databasename

    from disk='c:\transcation\testdb_20101205.trn'

    with norecovery

    but, we got the msg

    Msg 3117, Level 16, State 4, Line 1

    The log or differential backup cannot be restored because no files are ready to rollforward.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE LOG is terminating abnormally.

    please help me