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
|