Thanks, Mark - this was exactly the info I needed!
-steve

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Mark Yakushev
Sent: Wednesday, December 12, 2007 5:10 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] problem cloning sql server db

Steve,

You will need to relocate full-text catalogs also.

When relocating databases that contain full-text catalogs, the full text
catalog names will also need to be specified as values to /relocate ...
/to
options. E.g.

tdpsqlc restore  SQLDB1
/relocate=datafile1,datafile2,log1,sysft_PageCatalog
/to=d:\SQLDB1_copy2\datafile1.mdf,
d:\SQLDB1_copy2\datafile2.ndf,d:\SQLDB1_copy2\log1.ldf,d:\SQLDB1_copy2\P
ageCatalog
 /into=SQLDB1_copy2

Please note that the full-text catalog logical name is pre-pended with
sysft_. In the example above, directory d:\SQLDB1_copy2 has to exist
before
that restore.

Here is the full example. I have a full backups for the database SQLDB1.
The database has 2 data files, datafile1 and datafile2, 1 log - log1,
and a
full-text catalog PageCatalog.

C:\Program Files\Tivoli\TSM\TDPSql.524>tdpsqlc q tsm SQLDB1 /all

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 2, Level 1.06
(C) Copyright IBM Corporation 1997, 2006. All rights reserved.

Backup Object Information
-------------------------

SQL Server Name   ........................ ******\SECOND
SQL Database Name ........................ SQLDB1
Backup Object Type ....................... Full
Backup Object State ...................... Active
Backup Creation Date / Time .............. 10/09/2007 11:10:53
Backup Size .............................. 4,280,832
Database Object Name ..................... 20071009111053\00000D80
Number of stripes in backup object ....... 1



Restoring another backup of database into a new DB and new location:

C:\Program Files\Tivoli\TSM\TDPSql.524>mkdir d:\SQLDB1_copy2

C:\Program Files\Tivoli\TSM\TDPSql.524>tdpsqlc restore SQLDB1
/OBJECT=2007100911
1048\00000E48 /relocate=datafile1,datafile2,log1,sysft_PageCatalog
/to=d:\SQLDB1
_copy2\datafile1.mdf,d:\SQLDB1_copy2\datafile2.ndf,d:\SQLDB1_copy2\log1.
ldf,d:\S
QLDB1_copy2\PageCatalog /into=SQLDB1_copy2

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 2, Level 1.06
(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 wa
it...

Restoring metadata ...


Beginning full restore of backup object SQLDB1, 1 of 1,
  to database SQLDB1_copy2
Full: 0   Read: 4280832  Written: 4280832  Rate: 4,231.28 Kb/Sec
Restore of SQLDB1 completed successfully.


Total database backups inspected:               1
Total database backups requested for restore:   1
Total database backups restored:                1
Total database skipped:                         0

Throughput rate:                                4,227.00 Kb/Sec
Total bytes transferred:                        4,280,832
Elapsed processing time:                        0.99 Secs



Prior to TSM version 5.5, relocation of full-text catalogs can only be
done
via command-line interface.

Regards,

Mark
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm