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.
>
