How can I move the Full Text Catalog from one drive to another? SQL 2005
-
By default the FTC was placed on our C drive but in order to prevent space issues we want to move it to another drive on the same server. I have read that you cannot just move the FTC (please correct if that is wrong) so I was planning on doing a full backup of the database and then restoring the database over itself taking advantage of the option during restore to move/rename the db/log/ftc feature. Is this method ok? Dangers? Will there be issues in the database with regards to links to the old FTC name/location or do all those links get corrected during the restore of the FTC?
I did a practice restore on another server but noticed that the original FTC name stays the same regardless of weather I renamed and moved it during the restore. I assume this is to resolve the link issues I was curious about?
-
Do you mean the FTC login filename stays the same but it still moves the file for you as you hoped? If so, not a problem..? You could perform your backup/restore and then rename the original C: files and see if everything still functions...
-
I was going to try that soon....the renaming of the FTDATA directory where the original FTC lived. I moved, via the restore, the location as well as the FTC name. Although there isnt a real "file" name...just a directory with the new name and a collection of files under it. What I meant by the name staying the same was....when you go into the Storage>Full Text area the name of the Full Text Catalog remains the same as it was when originally created but apparently the directory associated with it get changed/moved to the new restored name....so unless you search the drive you'd never know it was renamed or moved. I can only assume that this is done to allow the Full Text indexes that were created on the individual tables to remain functional since they were "linked" (if thats the term I should use) to that name convention originally.
-
I did this on my dev server.....cloned a db....backed it up....tested Full Text searches on it....then restored OVER it with the backup I created but choosing to rename as well as relocate the FTC during the process. It appears as though the restore process, when you choose to rename/relocate, removes the old location. I went in to rename the old location to be sure it wasnt going to use it but it was gone and the new location was in play. Anyway...the full text search appears to be working still so this looks like a valid method of moving the FTC.
If anyone has any opinions or knows of any caviates please feel free to post
Thanks again!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply