Backup Central

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

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" <ADSM-L < at > VM.MARIST.EDU> 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" <ADSM-L < at > VM.MARIST.EDU>

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