| 
 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
 
  
Navigation:
[Reply to this message] 
 |