Re: TSM SQL restore
2007-03-08 10:23:04
Thank you very much, Del. That worked!
--
Mark Stapleton (mark.s AT evolving DOT com)
Senior consultant
________________________________
From: ADSM: Dist Stor Manager on behalf of Del Hoobler
Sent: Thu 3/8/2007 8:12 AM
To: ADSM-L AT VM.MARIST DOT EDU
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" <ADSM-L AT VM.MARIST DOT EDU> 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.
>
|
|
|