Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Restoring Multiple Transaction Logs for SQL 7

Author  Topic  Richie Starting Member 3 Posts Posted - 2001-07-10 : 18:54:02 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 (\\summitakback\sqlbackups\rasacbw\transactions\raacbw_*.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