Post reply

DBCC Errors -Migarting SQL 2000 database to SQL 2005

  • July 28, 2011 at 8:56 am

    #1360179

    When I run the upgrade adviser ,report shows component affected with the following message

    After upgrading to SQL Server 2005, Full-Text Search will not use operating system components such as word breakers and filters by default. To allow the use of these operating system components, use the sp_fulltext_service stored procedure and set load_os_resources to 1.

    Component: .asx

    Component: .css

    Component: .hta

    Component: .htt

    Component: .idq

    Component: .pps

    Component: .xps

    Component: .xsl

    Is this an issue?

    Thanks in adavance

  • July 28, 2011 at 9:19 am

    #1360217

    I won't be much help with FTS except to do Google searches on your behalf 😀

    This person was in the same boat as you: http://www.sqlservercentral.com/Forums/Topic678754-146-1.aspx

    Re: FTS in general, the extent of my knowledge is that it changed significantly from 2000 to 2005 under the hood. With a detach/re-attach you may be in for a little work. Your T-SQL syntax should be compatible but there could be changes in behavior and it appears you'll need to do a full rebuild/repop of your FTS indexes.

    From Upgrading Section:

    Installing and Upgrading Full-Text Search

    In SQL Server 2005, the format of full-text catalogs has changed significantly. This change requires all full-text catalogs from previous versions of SQL Server to be rebuilt. The rebuilding of full-text catalogs occurs automatically and does not prevent upgrade from completing. As a result, the rebuilding of full-text catalogs might continue after upgrade. A new folder is created under the path where the full-text catalog was originally located. The files associated with the rebuilt full-text catalogs are listed in this new folder.

    You're not technically upgrading in-place, but the idea is the same. The format of the index structures have changed such that you'll have to do a full rebuild of all indexes once you're over.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • July 28, 2011 at 9:30 am

    #1360230

    thanks!

Viewing 3 posts - 31 through 32 (of 32 total)

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