I have a full text index...in the properties of the index the path
shows...
C:\Program Files\Microsoft SQL Server\MSSQL\FTData
But if I look in the directory...I see nothing.
Yet...the system still lets me repopulate the index.
Is this normal? Should the index files be in this directory?
I searched the system for the .gthr files...and It shows them on the
D:\MSSQL\FTDATA directory.
This seems odd to me.They don't have to be in this directory, issue the following stored
procedure to find out where your files are
sp_help_fulltext_catalogs
Note the path column.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<mchi55@.hotmail.com> wrote in message
news:1168226858.291120.304230@.11g2000cwr.googlegroups.com...
>I have a full text index...in the properties of the index the path
> shows...
> C:\Program Files\Microsoft SQL Server\MSSQL\FTData
>
> But if I look in the directory...I see nothing.
> Yet...the system still lets me repopulate the index.
> Is this normal? Should the index files be in this directory?
> I searched the system for the .gthr files...and It shows them on the
> D:\MSSQL\FTDATA directory.
> This seems odd to me.
>
没有评论:
发表评论