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