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