TDP for SQL Server - restoring Database to another server

[director_den]

I want to restore a full backup object of database AHD to a different server (ASUIR1) than that wich it was backed up (ASUIR2). I run this command:

C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc restore AHD full

/fromsqlserver=asuir2



IBM Tivoli Storage Manager for Databases:

Data Protection for Microsoft SQL Server

Version 5, Release 1, Level 5.0

(C) Copyright IBM Corporation 1997, 2002. 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 ASUIR2\meta\0000.



The server ASUIR2 sees this backup object:

C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc q tsm AHD full /compat



IBM Tivoli Storage Manager for Databases:

Data Protection for Microsoft SQL Server

Version 5, Release 1, Level 5.0

(C) Copyright IBM Corporation 1997, 2002. All rights reserved.

Backup Object Information



SQL Server Name ........................ ASUIR2

SQL Database Name ........................ AHD

Backup Object Type ....................... Full

Backup Object State ...................... Active

Backup Creation Date / Time .............. 04/18/2005 04:04:32

Backup Size .............................. 31,867,392

Database Object Name ..................... 20050418040432\00001498

Number of stripes in backup object ....... 1

SQL Server Version ....................... 8.0.194

Cluster .................................. No

TDP Version .............................. 5.1.5.0

SQL Database Compatibility level.......... 80

SQL Database Data Space Allocated ........ 80,740,352

SQL Database Data Space Used ............. 32,505,856

SQL Database Log Space Allocated ......... 27,262,976

SQL Database Log Space Used .............. 6,643,712

SQL Database Options ..................... Truncate log on checkpoint

Select into / bulk copy

Torn page detection



I see this backup from Administrative Client too:

ASUIR2 Bkup ASUIR2\me- 1 BACKUPPOOL 60 0.23 0.23

ta\0000

ASUIR2 Bkup ASUIR2\da- 2 BACKUPPOOL 60 167.02 167.02

ta\0001



Anyone, please say me, what can I do?



Best regards,

Dennis

 

[may]

I had a similar problem, but the GUI Version worked fine, just don't foget to change your nodename parameter in TDPSQL's dsm.opt too.

 

[unpaired]

please checked TDP config file.
thank you...