|
Home > Archive > SQL Server Full-Text Search > July 2005 > Missing entry in sysfulltextcatalogs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Missing entry in sysfulltextcatalogs
|
|
| Allan Ebdrup 2005-07-21, 7:23 am |
| 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
| |
| Hilary Cotter 2005-07-21, 9:23 am |
| 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
>
>
| |
| Hilary Cotter 2005-07-21, 9:23 am |
| 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
>
>
|
|
|
|
|