I have inherited a SQL server that has about 15 databases that won't backup. The problems stem from old Full Text Catalogs that have been lost and the databases are now confused about which full text catalogs exists and where they are.
I managed to fix most of them by reindexing all the tables - which for some reason then allowed me to run DROP FULLTEXT CATALOG catalogname.
However, some of the databases aren't reporting that a Full Text Catalog exists, even though in sys.database_files a record FULLTEXT sysft_DATABASENAME s:\oldpath\ exists.
How can I get rid of the record for the Full Text Catalog in the sys.database_files table? Can the record just be deleted?