Post reply

How to change the Default Path of SQL Server 2000 Full Text in Cluster

  • April 19, 2009 at 3:04 pm

    #129416

    Hi People,

    I am doing an SQL Server 2000 Cluster SAN Migration where I had to move all System/User Databases to the New Drives on New SAN.

    I have moved all the components except full text. I changed the default path for the full text in the registry to the new drive where I placed the FTDATA folder. But the resource is not coming online. Im getting the below error in event viewer.

    An error occurred during the online operation for instance Fulltext>: 80070002 - The system cannot find the file specified.

    I see there are right permissions on the folder.

    Can anyone please let me know how to do this. Also, If you know the step by step procedure of changing the default path of Full Text to new drive on a cluster, please let me know.

    Thanks in Advance.

    -TGR

  • April 20, 2009 at 12:30 pm

    #980954

    Did you performed the below mentioned step:

    Allow system table updates by using the system stored procedure sp_configure and RECONFIGURE with override, and then update the [database_name].dbo.sysfulltextcatalogs path column to the new local drive or path destination for the full-text catalog default folder, such as d:\FTData.

    Please check "To move or copy full-text catalogs between local drives or paths on the same computer that is running SQL Server" section at http://support.microsoft.com/kb/240867 .

    MJ

  • April 20, 2009 at 6:17 pm

    #981132

    Thanks for the Reply.

    We don't have full text enabled for any of the databases. I am just trying to point the default path on to the new SAN drive. The resource is not coming online as I told.

    Also, if I delete the sql server full text resource from the Cluster Administrator, will it have any implications in future while patching etc.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply