Looks like I made a mistake I hope someone can help me with. I backed
up a SQL database that implements fulltext catalogs. I thought these
would be included in the backup...I was wrong. Not a problem to
recreate the catalogs except that the database still shows the
references to the old ones. It gives me an error if I try to delete. I
get an error if I try to rebuild. I have also tried command line with
no luck:
use dev_i3
EXEC sp_fulltext_catalog 'fcAttachment', 'drop'
I appear to be stuck because I have catalog references to catalogs that
do not exist on the new server. There must be a way to manually remove
this reference and start over...I hope!
Thanks in advance.
I hope you have found a solution but if not here's my 2 cents...
First, you'll want to double-check that full-text is enabled on the database
in the new server. (see sp_fulltext_database in BOL) If not, do so and try
once more to start a rebuild on the catalogs. If this doesn't work, you'll
need to manually delete the catalogs from the sysfulltextcatalogs table and
recreate the full-text catalogs (see sp_fulltext_catalog). This should get
your catalogs back online.
Thankfully, in SQL Server 2005, the FT catalogs will be backed up and
restored as part of the database.
Showing posts with label implements. Show all posts
Showing posts with label implements. Show all posts
Subscribe to:
Posts (Atom)