Kevin,
Do you mean that the TSM Server only contains versions that have
the corrupted data in them? Does that include the FULL backups too?
By "rolled" off... if you mean that it is no longer in the
TSM Server database repository... then you would need to restore
a backup of the TSM Server at a point in time that it contained
the data you are interested in restoring. If you don't have that,
then you are talking about a "salvage" situation.
If this is vital data... I would place a call with IBM service
immediately before the data on the tapes is gone as well.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/27/2005
09:32:34 AM:
> Del,
> This worked wonderfully, unfortunately, I applied the transaction logs
> with the transactions that corrupted the data in the first place. And
now
> the date that I need has "rolled off" of Tivoli. I know there is a way
to
> look and see what tape the old data could possibly be on, but I can't
> remember what it is. And I know it takes a fairly long time to run. If
you
> or any one of your fine friends can help that would be great.
> Thanks Again,
> Kevin
> Kevin M. Lipscomb
> Dan River Inc.
> Systems Engineering
> kevin.lipscomb AT danriver DOT com
> 434-799-4823
>
>
>
> Del Hoobler <hoobler AT US.IBM DOT COM>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 01/26/2005 12:52 PM
> Please respond to
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
> To
> ADSM-L AT VM.MARIST DOT EDU
> cc
>
> Subject
> Re: MSSQL single database restore
>
>
>
>
>
>
> Kevin,
>
> If you want to restore a specific inactive backup first you should
> query all the backups for the specific database, for example:
>
> tdpsqlc query tsm dbname /all
>
> This will show you all active and inactive the backups for the
> specific database.
>
> Then... you should perform the restore specifying the exact
> full backup object name that you want to restore using the
> /OBJECT parameter. For example:
>
> tdpsqlc restore dbname full /object=<backup-obj-name>
>
> Note: If you also have "log" backups to restore, you should use the
> /RECOVERY=NO on the restore of the full and then restore
> additional log backup objects, specifying the /RECOVERY=YES
> on the restore of the last log backup. For example:
>
> tdpsqlc restore dbname log=* /object=<backup-obj-name>
> /recovery=yes
>
> See exact details of command-line syntax and examples of restoring
> inactive backups in the User's Guide.
>
> As far as chasing down the hang situation, you can place a call
> with IBM Support.
>
> Thanks,
>
> Del
>
> ----------------------------------------------------
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/26/2005
> 11:42:38 AM:
>
> > Hello All,
> > I am attempting to restore a single database on a fairly busy SQL 2k
> > server. I need to go back to a certain point in time because the data
is
> > corrupt after this time. Whenever I use the GUI for TDP for MSSQL and
> try
> > to look at the active/inactive, tdpsql freezes (I think it runs out of
> > memory). So I have tried my hand at the command line. However, I
cannot
> > figure out how to go back and get the last full backup at this moment.
> All
> > I can determine is how to get logs back.
> > Unfortunately, I am not a DBA and our DBA does not work with TSM so we
> are
> > at an impasse.
> > If someone could give some assistance that would be great.
> > Thanks,
> > Kevin
> > Kevin M. Lipscomb
> > Dan River Inc.
> > Systems Engineering
> > kevin.lipscomb AT danriver DOT com
> > 434-799-4823
|
