Post reply

moving a database with full text indexing from sql 2000 to 2005

  • September 14, 2008 at 8:40 pm

    #190767

    Hi Folks,

    how do I move a database to a different server that has full text indexing enabled from sql 2000 to 2005?

    The full-text index will not migrate for me at present.

    I noticed the the properties for the full- text catalog on the current database has a null value for last population date. This would indicate the index has never been used right?

  • September 22, 2008 at 2:38 pm

    #875273

    Does this article help? http://www.sqlservercentral.com/articles/SS2K5+-+Full+Text+Searching/2819/[/url]

    I believe you have to drop and recreate if I remember correctly.

    MCITP, Database Administrator
    A hodgepodge of Information Technology and Life
    LinkedIn Profile
    My Twitter

  • September 23, 2008 at 7:08 am

    #875618

    The best thing to do is to drop and recreate. This way, you'll be sure that everything is correct under SQL Server 2005.

    You'll also get the opportunity to adjust/change any specifications in the full-text index under SQL Server 2005.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply