SQL 2005, Clustered FullText dependencies?
After installing SQL Server 2005 on a cluster, I notice that the cluster resource "SQL Server FullText" has a dependency on disk H.
Disk H was the disk I chose for Data Files during install.
I would have expected the dependency would be "SQL Server" as it was in SQL 2000.
Is this a bug?
I took a random database and added a Full Text Catalog. In the Browse section, I chose a clustered disk other than H (namely F) for the Catalog Location.
So should the FullText resource now have a dependency on the F-disk as well?
[581 byte] By [
JFoushee] at [2007-12-24]
Fulltext is cluster-aware in sql2k5 and it must be located on the shared disk. If you do not specify the INPATH value during the catalog creation, the default path (set at setup time) will be used.
http://msdn2.microsoft.com/en-us/library/ms189520.aspx
oj at 2007-10-8 >
Well, no there's not. I added Disk F to the SQL Server dependency list.
Again, out of the box, the FullText resource just has a dependency on the H-drive as installed.
I would have expected the FullText resource to have a dependency on the SQL Server resource (where I set my disk dependencies), which was the behavior of SQL 2000.
I posted this dilemma to the Microsoft Feedback Center and their answer was "This is by design." Design of the product or the install? Oh well, I guess it works.
