Hi,

I have a requirement of refreshing test database with the online backup of production ,also need to apply some log files ,Kindly help me for the same

Do we need to use the redirected restore procedure ,if yes..After restore will the db be in rollforword pending state...

Please provide the syntax for restore and appling the archive log files


thanks

with regads
ashaq

Ashaq,

To answer your questions:

1) Redirected restore will be necessary if the directory structure of the DB of your test and production servers are different.

2) Yes, they will be in rollforward pending

3) The syntax depends on your particular setup. Read the manual for RESTORE and ROLLFORWARD (the Command Reference has these).

Andy