This should work. Have you tried using the CLI and the "/RELOCATEDir=directory" option? For example, restoring from server1 to server2, it would be something like this: (The following is all one command.)
TDPSQLC RESTORE db1 full /FROMSQLSERVER=server1 /SQLSERVER=server2 /REPLACE /RELOCATEDir=c:\tempdir If you still have a problem, place a call with IBM support. Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> wrote on 07/31/2008 11:38:30 AM: > [image removed] > > error restoring sql db that has full text indexing > > Schaub, Steve > > to: > > ADSM-L > > 07/31/2008 11:40 AM > > Sent by: > > "ADSM: Dist Stor Manager" <[email protected]> > > Please respond to "ADSM: Dist Stor Manager" > > Tsm server 5.4 > > Tsm tdp 5.5.0.0 > > > > Trying to restore a large db from one sql server to another. I believe > the errors point to the fact that the original db has 2 full text > indexes. I'm trying to use the gui for the restore, I've tried both > specifying placement for the db/log/other file as well as checking the > "individual" option. The help file indicates that these are the options > to allow a correct restore in this situation but we cant seem to get it > to work. > > > > Here is a snip of the log (note that there is no E: drive on the target > server, so it sounds like it is not respecting my overrides): > > > > 07/31/2008 11:20:22 Restore of Carekey failed. > > 07/31/2008 11:20:22 An exception occurred while executing a Transact-SQL > statement or batch. > > 07/31/2008 11:20:22 The path 'E:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\FTData\Carekey BoardSearch' has invalid attributes. > It needs to be a directory. It must not be hidden, read-only, or on a > removable drive. > > 07/31/2008 11:20:22 File 'sysft_Carekey BoardSearch' cannot be restored > to 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\Carekey > BoardSearch'. Use WITH MOVE to identify a valid location for the file. > > 07/31/2008 11:20:22 The path 'E:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\FTData\Carekey ConceptSearch' has invalid > attributes. It needs to be a directory. It must not be hidden, > read-only, or on a removable drive. > > 07/31/2008 11:20:22 File 'sysft_Carekey ConceptSearch' cannot be > restored to 'E:\Program Files\Microsoft SQL > Server\MSSQL.1\MSSQL\FTData\Carekey ConceptSearch'. Use WITH MOVE to > identify a valid location for the file. > > 07/31/2008 11:20:22 Problems were identified while planning for the > RESTORE statement. Previous messages provide details. > > 07/31/2008 11:20:22 RESTORE DATABASE is terminating abnormally. > > Thanks, > > Steve Schaub > > Systems Engineer, WNI > > BlueCross BlueShield of Tennessee > > 423-535-6574 (desk) > > 423-785-7347 (cell) > > ***public*** > > Please see the following link for the BlueCross BlueShield of > Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
