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
