Re: [ADSM-L] error restoring sql db that has full text indexing

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 DOT 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 DOT 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