Thank you very much, Del. That worked! -- Mark Stapleton ([EMAIL PROTECTED]) Senior consultant
________________________________ From: ADSM: Dist Stor Manager on behalf of Del Hoobler Sent: Thu 3/8/2007 8:12 AM To: [email protected] Subject: Re: [ADSM-L] TSM SQL restore Hi Mark, Are you using the same TSM NODENAME in the DSM.OPT file that was used to back up the databases? If not, try this: 1. Copy the DSM.OPT file from the SERVER1 machine to the SERVER2 machine. Call it something like, SERVER1.OPT 2. Connect to the TSM Server from this machine, storing the password. TDPSQLC QUERY TSM /TSMOPTFile=SERVER1.OPT /TSMPASS=password 3. Make sure you can see the backups: TDPSQLC QUERY TSM * /TSMOPTFile=SERVER1.OPT 4. If everything above works, retry the restore. TDPSQLC restore DBA_Admin full /RECOVery=No /fromsqlserver=SERVER1 /TSMOPTFile=SERVER1.OPT TDPSQLC restore DBA_Admin log=* /fromsqlserver=SERVER1 /TSMOPTFile=SERVER1.OPT There is a IBM Technote that explains this for the DP/SQL GUI: http://www-1.ibm.com/support/docview.wss?uid=swg21105967 Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 03/08/2007 08:37:51 AM: > Very similar. I get this: > > D:\TDPSql>tdpsqlc restore DBA_Admin full /fromsqlserver=SDHQ04-DEVSQL04 > IBM Tivoli Storage Manager for Databases: > Data Protection for Microsoft SQL Server > Version 5, Release 3, Level 3.0 > (C) Copyright IBM Corporation 1997, 2006. All rights reserved. > Starting Sql database restore... > Querying Tivoli Storage Manager server for a list of database > backups, please wait... > ACO0261I There are no backups for the server named SDHQ04-DEVSQL04\meta\0000. > > And I know there are backups there. >
