I am having difficulties restoring multiple transactions logs up to a specific time.
I am running the following from the command prompt:

D:>FOR %i in (\summitakbacksqlbackups
asacbw ransactions
aacbw_*.dat) do osql -Usa -P******* -Sradevl3 -dmaster -Q"restore transaction drtest from disk='%i' WITH NORECOVERY, STOPAT='10 July 2001 13:41'"

I get the follwing error:
Msg 3031, Level 16, State 1, Server RADEVL3, Procedure , Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has inconsistent
or conflicting options. Remove the conflicting option and reissue the
statement.

If I remove the 'WITH NORECOVERY' option SQL Server defalts to 'WITH RECOVERY', which only allows the first file in the sequence to be restored.

If I remove the 'STOPAT' option I have to restore all files except for the last one that has the transaction that I would like to restore up to and run it manually with the 'WITH RECOVERY' option.

Can anybody offer some assistance here?

Thanks in advance
Richard