December 16, 2012 at 11:13 am
Hi Administrators :),
I need to duplicate one database. It should be copied on same server, just with other name.
That is done by my colleague, but he did not take care to separate full text catalog. The problem is that I ended now with two databases which shares same full text catalog.
Is there any option to remove full text catalog from only second database, and not delete it because it should be used by first database.
And then maybe copy its content on other place in different folder name, and attach it to second database?
So, two databases now share same full text catalog.
What will happen if I go to second database and delete the catalog from Management Studio? Will that delete catalog completely, for first database too?
December 17, 2012 at 12:12 am
Boris Pazin (12/16/2012)
Is there any option to remove full text catalog from only second database, and not delete it because it should be used by first database. What will happen if I go to second database and delete the catalog from Management Studio?
yes you can delete it but first you have to drop related fulltext index then only otherwise you will get below error (plus not sure how it will impact you search)
Msg 7668, Level 16, State 1, Line 1
Cannot drop full-text catalog 'catalog_fulltext_XXX' because it contains a full-text index.
Boris Pazin (12/16/2012)
Will that delete catalog completely, for first database too?
absolutely NOT.it will only work on targeted database (use database_name)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply