Recently a customer of mine pointed out the fact that you could use the TDP for 
SQL to restore to a point in time which means replaying part but not all of a 
log.  I actually didn't know you could do this. For all of the DR tests I've 
been involved with we've wanted to get all the data in the logs.
 
Finding out they could do this brought up the following question. If you first 
choose to reply to a certain point in time say today at 15:00 and then after 
the restore you find that you really needed to replay the logs up to 16:00 can 
you go back in through the TDP or by any other means and choose to reply 
another hour of the log?  Or, do you have to perform the entire restore over 
again stating this time with a point in time of 16:00.
 
Del?, Anyone?
 
Kyle

                
---------------------------------
 Start your day with Yahoo! - make it your home page