Del,

This is the TDP for SQL.  Someone made a change in January which
should not have been made.  On the regular policy, we have 14 copies
of the FULL, which takes us back to 2/12/02.  For some reason there
are also a large number  of logs not associated with an existing
full, going back to December of last year.  What the DBA would like
to do is to restore those logs to disk for his log analyzer tool to
deal with.  Is there any way to do this?



At 11:51 AM 2/26/2007, you wrote:

Fred,

Are you referring to Data Protection for SQL?
If so, you can use the GUI to just restore the log backups.
Just remember that you need to uncheck the "Recovery" box
EXCEPT on the last log that you restore.

Thanks,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/26/2007
12:38:04 PM:

> Is there a way to restore a log only from the SQL Agent?  There are
> numerous logs from a date preceding the loss of a DB, created by the
> SQL Agent, but the gui for the agent wants to restore them to an
> existing full.  Is there any way to salvage this?

Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464