The Full-Text Search component is not completely rolled back to the Service Pack 1 version after you uninstall Cumulative Update 3 for SQL Server 2008 Service Pack 1 that is applied by using a slipstream installation

Article translations Article translations
Article ID: 973888 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario:
  • On a Microsoft Windows-based computer, you apply Cumulative Update 3 for SQL Server 2008 Service Pack 1 by using a slipstream installation. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
    971491 Cumulative update package 3 for SQL Server 2008 Service Pack 1
  • You try to uninstall this cumulative update after the slipstream installation.
In this scenario, the Full-Text Search component is not completely rolled back to the SQL Server 2008 Service Pack 1 version.

To confirm whether you are encountering this issue, you can check the SQL Server Full-Text Key file (Sql_fulltext_keyfile.dll) in the SQL Server 2008 Installation folder. Typically, this file is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\MSQL10.<Instance Name>\MSSQL
If this file has a file version that is greater than 10.00.2531.00, the Full-Text Search component is not completely rolled back to the SQL Server 2008 Service Pack 1 version.

WORKAROUND

To work around this problem, follow these steps:
  1. In Control Panel, open Add or Remove Programs.

    Note For Windows Vista or for Windows Server 2008, open Programs and Features.
  2. In the Currently installed programs list, click Microsoft SQL Server 2008, and then click Change/Remove.

  3. Note For Windows Vista or Windows Server 2008, right-click Microsoft SQL Server 2008, and then click Change.
  4. In the SQL Server 2008 dialog box, click Remove.
  5. Select the appropriate instance or instances, and then click Next.
  6. In the Select Features window, select Full-Text Search from the Features list.
  7. Complete the Remove SQL Server 2008 wizard, as appropriate for your configuration.
  8. Click Start, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Installation Center.
  9. Click Installation, and then click New SQL Server stand-alone installation or add features to an existing installation.
  10. In the Browse For Folder dialog box, locate the SQL Server 2008 installation folder that you want, and then click OK.
  11. In the SQL Server 2008 Setup window, click Next to move to the Installation Type phase.
  12. Click Add Features to an existing instance of SQL Server 2008, select the appropriate instance in the drop-down list, and then click Next to move to the Feature Selection phase.
  13. Select Full-Text Search from the Features list.
  14. Follow the steps in the Full-Text Search installation wizard.
Note There is no workaround for cluster scenarios. To roll back the cumulative update, you must reinstall the clustered instance of SQL Server.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 973888 - Last Review: August 21, 2009 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
Keywords: 
kbexpertiseadvanced kbtshoot kbsurveynew kbprb KB973888

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com