Thanks Del.  The last full is 2/12/07, but there are those
disassociated logs from January.  The DBA hoes there is a way to
restore them as simple bit strings.  Then his magic log analyzer can
find his deletes and convert them to inserts.  I've said there's no
hat and no bunny, but he calls every few minutes to see if I've found
one yet.  I'll send him your response and tell him case closed.


At 04:27 PM 2/26/2007, you wrote:

Fred,

There is no way to restore DP/SQL backups to a "file".
SQL backups are a "stream of bits"... only the SQL Server knows
how and where to place the bits back into the one (or more) .LDF log
files.
(This is not like Exchange... where we can restore
the .LOG files to a separate directory.)

If you can find out where the FULL backup is
(look back at your SQL Server log and/or backup history
within the SQL Server databases).. to find out
where/who ran that SQL Server backup...
... you might be able to find out where it is.

If you have all of the logs prior to the full backup in question...
... you can try restoring the previous full backup and then all
of the logs for that one ... and then restore the logs for
full backup in question.

Keep in mind you can always restore to a different location,
so that you do not write over any existing database or log files.

Thanks,

Del

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


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/26/2007
03:15:36 PM:

> 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

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