November 14, 2005 at 7:03 am
Hi,
Having successfully restored a database to another server with all user/logins resolved, there remains an issue with the Full Text catalog. It was previously on an i: drive, but the new server has no i: drive.
If I try to delete it, I get an error 20565 [SQL-DMO] Database is not full-text enabled yet.
Is there a way of forcing the deletion of a non-existent full text catalog so I can create a new one, or of changing the location of the FTC ?
Many Thanks,
Angus
November 15, 2005 at 8:27 am
This is a bug related to moving / restoring FT-enabled databases to another
server where the drive letter for the FT Catalogs is different than the
orgianal server. You can work around this this "Catch-22" situation with the
following code (Note: Sysadmin level permission is required):
-- Enable System Table UPDATEs
sp_configure allow,1
go
reconfigure with override
go
use <your_user_database_name>
go
-- Record FT Catalog info. (Note: path = NULL)
select * from sysfulltextcatalogs
go
UPDATE sysfulltextcatalogs set path = '<new_drive_letter:\<new_directory>'
WHERE ftcatid = <ftcatid_of_affected_catalog>
go
-- Record new FT Catalog info.
select * from sysfulltextcatalogs
go
use master
go
-- Disenable System Table UPDATEs
sp_configure allow,0
go
reconfigure with override
go
Once you execute the above SQL code, you should be able to delete the "non-existing" FT Catalog. If not, let me know the exact version (@@version) that you are using and I can email you a SQL script that will clear up this issue for you.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
John T. Kane
September 25, 2006 at 4:06 pm
I am having a similair issue and after the update to sysfulltextcatalog still get the error message. ANy suggestions?
December 14, 2007 at 10:13 am
i AM ALSO FACING THE SAME PROBLEM.
ERROR:21776 [SQL-DMO] THE NAME 't1' was not found in the full text catalogs collection. If the name is qualified name, use[] to separate various parts of the name and try again'.
Kindly advise.
Thanks and regards,
S.Srinivasan
June 4, 2009 at 8:16 am
It works! To get ftcatid:
"select * from sysfulltextcatalogs"
execute this on DB that has catalog.
May 5, 2010 at 12:58 pm
it does not work in SQL 2005 as i receive the following message:
Msg 259, Level 16, State 1, Line 1
Ad hoc updates to system catalogs are not allowed.
It does not allow the changes to sysfulltextcatalogs.
Help!!!
November 5, 2015 at 5:55 pm
Get the filename from the original server and restore with move to a new drive
When the database is restored on SQL Server 2012 from SQL server 2005, a new database file will be created for the full-text catalog.
http://mssqlfun.com/2012/11/19/restoring-a-sql-server-2005-full-text-catalog-to-sql-server-2012/
November 8, 2015 at 9:48 pm
Try this syntax to drop full text catalog
DROP FULLTEXT CATALOG catalog_name
August 12, 2020 at 7:06 am
This was removed by the editor as SPAM
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy