Posted by Chloe C on 10/23/06 12:32

Hi

I think I must be particularly dozy this morning.

Each morning a database is backed up toa file on a remote server, and
every 15 mins after that a transaction log backup is appended to the
same file on the remote server.

When we want to restore the database on the remote server, we appear
to have to restore each transaction log backup individually - is that
correct? Doing this through EM is tedious and error-prone - does
anyone have a script which could automate the process (at least a
bit!).

I can't help feeling the "Read backup set information and add to
backup history" option should be of use here, but it doesn't seem to
do a lot.

Chloe

[Back to original message]