Missing entry in sysfulltextcatalogs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allan Ebdrup - 21 Jul 2005 12:54 GMT

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

Reply to this Message

Hilary Cotter - 21 Jul 2005 14:56 GMT

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.

Signature

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

> Hi
> I've just restored a database from a backup, usually I have to correct the
[quoted text clipped - 8 lines]
> Kind Regards,
> Allan Ebdrup

Reply to this Message

Hilary Cotter - 21 Jul 2005 15:03 GMT

BTW - don't you mean you have to correct the path in the database's
sysfulltextcatalogs as opposed to master's?

Signature

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

> Hi
> I've just restored a database from a backup, usually I have to correct the
[quoted text clipped - 8 lines]
> Kind Regards,
> Allan Ebdrup

Reply to this Message