Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2005-04-03 : 19:14:47
|
| Hi,i moved my database to a new server, and the full-text catalog seems be messed up. I tried to remove it from the table and it said to use sp_fulltext_catalog to fix the issue.I ran the query:use masterselect * from sysfulltextcatalogs and i got back 0 results.What options do I have? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-03 : 19:25:44
|
Well, assuming you have the script to recreate the full-text catalog (you do have that, don't you?), you could run sp_fulltext_database 'disable' followed by sp_fulltext_database 'enable'. That will reset the entire system. Theoretically, you should be able to rebuild then.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-04-03 : 19:41:05
|
| Hi,I don't have a script, i just use EM and then set a schedule.Ok I ran the query, and when I tried to drop full-text index it says"Error 7605: full-text catalog 'catalog_XXX' has been lost. Use sp_fulltext_catalog to rebuilt and to repopulate this full-text catalog"it seems there is a reference to the full-text in the database, but my Master has no idea about it? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-03 : 20:09:26
|
| That's correct. We had this same error one time when I moved our databases to a new server. If you ran both those commands though, you should be able to recreate the index. Try it and let me know how it goes. I wish I would have written down the exact steps I took. Oh well, such is life.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-04-03 : 20:50:44
|
| Hi,Actually I did run both of the queries you gave me, i ran the 1st one. then pasted the 2nd one into QA and ran it. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-04-03 : 20:56:17
|
| And, have you rebuilt the full-text catalog? Will it let you rebuild it now?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
sql777
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-04-03 : 22:42:42
|
| it doesn't seem to do anything. When I set a schedulate it complains with the same error.Maybe I should create another table, then delete the old one. then rename the other table back to the original and create an index from scratch? |
|
|
|
|
|
|
|
|
full-text catalog disappeared