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 [EMAIL PROTECTED] 434-799-4823
Del Hoobler <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 01/26/2005 12:52 PM Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] 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" <[email protected]> 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 > [EMAIL PROTECTED] > 434-799-4823
