Missing entry in sysfulltextcatalogs

Hi
I've just restored a database from a backup, usually I have to correct the
path of the fulltext index in master.sysfulltextcatalogs after doing this,
but now sysfulltextcatalogs is empty and has no entries. When I right click
the table with the fulltext index I can see that it has a fulltext index
defined.
Has anyone got an idea of what's going on, why is sysfulltextcatalogs
showing up as empty?
Kind Regards,
Allan Ebdrup
I am confused, you restored a database from a backup and you expect the
sysfulltextcatalog table to contain an entry for this catalog?
I take it that the original backup was done on this machine and is not from
a remote server, and that the database have tables which were full text
indexed before you restored the backup.
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
"Allan Ebdrup" <comaeb@.ofir.com> wrote in message
news:ehtEprejFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hi
> I've just restored a database from a backup, usually I have to correct the
> path of the fulltext index in master.sysfulltextcatalogs after doing this,
> but now sysfulltextcatalogs is empty and has no entries. When I right
click
> the table with the fulltext index I can see that it has a fulltext index
> defined.
> Has anyone got an idea of what's going on, why is sysfulltextcatalogs
> showing up as empty?
> Kind Regards,
> Allan Ebdrup
>
|||BTW - don't you mean you have to correct the path in the database's
sysfulltextcatalogs as opposed to master's?
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
"Allan Ebdrup" <comaeb@.ofir.com> wrote in message
news:ehtEprejFHA.3164@.TK2MSFTNGP15.phx.gbl...
> Hi
> I've just restored a database from a backup, usually I have to correct the
> path of the fulltext index in master.sysfulltextcatalogs after doing this,
> but now sysfulltextcatalogs is empty and has no entries. When I right
click
> the table with the fulltext index I can see that it has a fulltext index
> defined.
> Has anyone got an idea of what's going on, why is sysfulltextcatalogs
> showing up as empty?
> Kind Regards,
> Allan Ebdrup
>