INF: ????? SQL Server 2000 Service Pack 3 Rebuilds ???? ??????? ??????? ???? ????

?????? ????????? ?????? ?????????
???? ???????: 327217 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????


????? ???? ??? ??????? ?? ?????? ???? ?? ????? ?? ?? ???? ??????????? (FTS) ???? ?????? ????? CONTAINSTABLE ?? FREETEXTTABLE
?? ??? ????? ??? ????? ??????? ??????? ????????. ?? ??? ????? ????? ??? ??? ?? ????? ???????? ????????. ???
??? ??? ????? ????? Microsoft ?????? ????? ?? ????? ?????? ???? ??????. ????? ????? ??? ???????
???? ??????? ??????? ???? ?????? ??? ????? ???? ??? ??????? ??? SQL Server 2000 ?????? ????? ?????? Service Pack 3 (SP3).
????? ??? ??????? ??? ??????? ??? ?????? ??????? ?? SQL Server 2000 SP3 ?????? ??? ?? ????.
????? ????? ??????? ???? ?????? ?????? ??? ???? ??? ?? ???? ???? ?? ????
??? ??????? ??? SQL Server 2000 SP3.

??? ????? ????? ???? ??????? ??????? ???? ?????? ??? ????? ????? ?????? ???? ??????. The
????? ??????? ??????? ??? ??????? ???????? ??? ??? ????? ???? MSSearch ??? SQL Server 2000
?????? ??????? SP3. ??? ???? ?? ??????? intitial ????? SQL Server 2000 SP3. ????
??? ??? ??? ????? ????? ????? ??? ??? ???? ??????? ??????? ???? ??????. ?? SQL Server 2000 SP3
??????? ????????? ??? ????? ??? ??? ????? Microsoft Search ??????
SQL Server 2000 SP3 (?????)
???? ????????.

??????? ???? ??????? ??????? ?? ???? ?????? SQL Server 2000 ??? ??? ????????? ???? ????? ????? ? ???? ???
?????????? ???????? ?????? ???? ?? ??????. ?? ???? ????? ????? ????? ?????
??????? ?????. ?????? ????? ?? ????? ??????? ??????? ???? ?????? ??? ??? ????? ?????.

?????

???? ??? ????? ?? ????? ???????? MSSearch ??? ????? ?? ????? ????
?? ??????? ?????? ??????????? CONTAINSTABLE ? FREETEXT ??? repopulations ?????? ??????? ?? ??????
??????? SQL Server.

????

??? ??????? ??? ????? MSSearch ?? ????? ?????? ???????. ???
????? ????? ???????? MSSearch ? ?? ????? ??????? ???????? ??
?????? "??????".

???? ??????

??????? ?????? ??? ?????? ????? ??????? ??? ???????? ???????:

  • ????? ????? ??? ???
  • ????? ??? ?????? ??
  • ????? ?????????
???? ?? ????????? ??? ?? ??? ?? ???????.

????? ?????? ??? ????


??????: ???????? ????? ?? ???? ???? ?? ????? ??? ????
??? ????? ???????. ???????? ??? ??? ?????? ???? ?????? ?? ????? ?????? ???????? ? ?? ?? ???? ???? ???
????? ????? ????? ??? ???. ??? ??? ????? ?????? ??? ?????? ?? ???? ?????? ???? ???? ??? ????
????? ???? ?? 100,000, ?? ?????? ????? ????? ????? ???? ?? ???? ???????? ??? ????????
????? ?????? ??????. ??? ??? ???? ???? ???? ?? 100,000 ?? ????? ??? ??????? ????? ??? ???
?????. ???????? ??? ???? ??????? ??? ???? ?????? ??? ????? ???? ??????? ??????? ?? ??
?????? SQL Server 2000 ??? ?????????.

????? ??? ???? ??? ?? ???? ???? ????? ????? ????? ????? ? ?????? ??????
??????? ??? ??????? ??? SQL Server 2000 SP3 ???? ??????? ??????? ????? ????? ????? ???:
  1. ????? ??? ??????? ????? ????? ?????? SQL Server. ?????? SQL Server ??? ????? ?????????? ?????? ???? ????????? ??????? ???????? ??? ???? ??????? ?????. ????? ?? ????????? ??? ????? ??????? ??? ??????? ????? ???? ??????? ????????? ??????? ???? ??????? "??????? ?????? ?????????" ?? "??? SQL Server ???????".
  2. ?? ???? ????? "????" ??? ???? ??????? ?????? ???? ??????? ??????? ?? ????????? ????????. ????? ??? ?? ????????? ????? ?? ???????? ????????.
  3. ??????? ????? ?????????? ??????? ?? ?????? 1 ??? ????????? ???????. ???? ?? ?? ??????? ????? ???????? ?? ?????. ??? ????? ????? ???????? ???? ?????? ?? ????????? ????? ????? ??? ????????? ??????? (???? ?????? 6).
  4. ??? ?? ??? ????? ????? ?????????? ????????? ????? ??? ?????? ?????? ???????? ???? ?????? ?? ????? ????????. ??? ???? ??? ?? ???? ??? ??????? ??????? ???? ??????. ????? ????????? ???????? ??????? ??? ???? ????? ???? ???? ???? ???? ????? ??????? ??????? ??? ???????? ?????:
    sp_fulltext_catalog 'fulltext_catalog_name', 'rebuild'
    go
    sp_fulltext_catalog 'fulltext_catalog_name', 'start_full'
    go
  5. ????? SQL Server 2000 SP3 ??? ???? ??????? ?????? ???????? ?????? ???? ??????.
  6. ??? ????? ????? ??????? ??? ???? ??????? ??????? ???? ?????? ??? ?????? ??????? ??? ???? ??????? ??????? ???? ?????? ??? ???? ??? ??? ???? ???????. ??? ??????? ??? ???????? ???????? ?? ?????? ???? ?????? ?? ??? ?????.
  7. ??? ???????? ????? SQL Server 2000 SP3 ??? ???? ???????.
  8. ??? ?????? ??????? ??? SQL Server 2000 SP3 ????? ???? MSSearch.

    ??????: ??? ?? ??? ????? ????? ??????? ??????? ??????? ?????? ?? ????? ??????? ??? ?? ??????? ??????? ?????? ?? ?? ???? ????? ??? ????????? ????????:
    sp_fulltext_catalog 'fulltext_catalog_name', 'stop'
    ??? ?????? ??????? ????? ???? MSSearch.
  9. ??? ???? ??????? ??????? ??????? ??????? ???????? ??????? ??????? ???? ?? ????? ?? ???? ???????.
  10. ??? ????? ???? MSSearch.
  11. ?? ???? ????? "????" ??? ???? ??????? ??? ??????? ????? ????? ???? ???? ??????? ??? ??????? ???????? ???? ???? ?????? ?????? ????? ????? ?????? ?? "??????? ????":
    sp_fulltext_table '%tablename%', 'update_index'
    ??? ???? ??? ????? ????? ?? ?????? ???? ??????. ???????? ??? ???? ??? ?? ????? ???? ?? ????? ????????? ???? ??????? ?? ????????? ???????? ?? ?????? 2 ???????.

????? ??? ?????? ??

????? ??????? ?????? ?????? ?????? ??? ????? ??? SQL Server 2000 SP3 ???? ??????? ??????? ????? ????? ?????? ???:

??????: ?? ????? ??????? ??????? ??? ?? ???? ??? ?????? ????? ????? ?????. ????? ??? ?????? ?? ???? ??????? ?????? ?????? ??? ?????? ??????? ????? SQL Server 2000 SP3; ??? ???? ??????? ??????? ???? ?????? ?? ???? ??? ????? ????? ???? ?? ????? ????? ??? ???.

  1. ??? ????? SQL Server 2000 SP3 ??? ???? ????? ????? ??? ???????? ???????? ?????? ???????:
    exec sp_help_fulltext_catalogs
    exec sp_help_fulltext_columns
    ???? ????????? ??????? ?? ??? ??? ????????? ?????? ????? ??????? ??? ????? ????? ??????? ??????? ???? ??????.
  2. ??????? sp_fulltext_tablesp_fulltext_catalog ????? ??????? ????? ???? ??????? ??????? ???? ??????. ??? ?? ????? ??????? ???????? ???? ?????? ??? ????? ??????? ??????? ???? ??????.
  3. ????? ????? ????????? ??????? SQL Server.
  4. ????? SQL Server 2000 SP3. ????? ????? ??????? ???? ????? ????? ??????? ?? ???? ??????? ??????? ???? ?????? ??? ???? ????? ??????? ??? ??????? ??? SQL Server 2000 SP3. ????? ????? ??? ??????? ??? ????? ???? ??????? ??????? ???? ??????.
  5. ??? ??? ???? ????? ????? ???? ??????? ??????? ???? ?????? ???????? ??????? sp_fulltext_catalog ?????.
  6. ????? ???? ??????? ???? ?????? ????? ??????? ???????? ??? ?????? ??? ??????? ??????? ???? ???? ?????? ?? ?? ?????? ????? ????? ??? ???? ??????? ??????? ???? ??????.

????? ?????????

??? ??? ????? ???????? ???? ??????? ??????? ???? ?????? ???????? ????? (??? ?? 10,000 ???? ?? ??? ?????) ? ????? ????? ?????? ample ??????? ????? ??????? SQL Server 2000 SP3 ? ?? ?? ???? ???? ??? ????? ????? ????? ??? ??? ?? ?????? ???. ??? ??? ???????? ??? ?? ????? ???? ???? ???? ?? ???? ????? ????? ????? ????? ????? ?????? ?? ??????? ??????.

?? ???? ??????? ??? ??????? ??? SQL Server 2000 SP3 ?????? ????? ??????? ??? ???? ???????. ????? ??? ??????? ????? SQL Server ? ?????? ?????? ??????? ???? ?????? ???? ?? ?? ???? ????? ?????.

??????? ????


????? ??? ???? ?? ?????? ?? ??????.

???? ??? SQL Server 2000 ?????? ????? ?????? Service Pack 2 (SP2). ????? ?? ???? ????? ??????? ??????? ???? ??????. ???? ????? ????? SQL Server 2000 SP3 ??? ???? ???? ??????? ??????? ???????? ??? ????????. ??? ????? ?? ????? ??????? ??????? ???????? ??? ???? ??? ????? SQL Server 2000 SP3 ???? ?????? ?????.

???? ?? ???? ??? ??????? ??? ?? ????? ?????? ???? ??? ????? ?? ???? SQL Server 2000 ??? SQL Server 2000 SP3. ?? ????? ???????? ???? ??? SQL Server 2000 SP3 ??? ??? ???? ????????? ??? ??????.

?????? ?? ??? SQL Server 2000 SP3 ??????? ????? ?? ??? ??? ??? ????? ???? MSSearch ???? ???? ??????? ???????? ?????? ??? ???? CPU I/O ?????. ?????? ???? ?????? ????? rebuilding ? repopulating ???? ??????? ??????? ???? ?????? ??? ??????. ????? ???? ?? ???? ????????? SQL Server ??????? ??????? ????????. ?? ???? ??????????? ????? ???? ?? ?? ???? ????? ????? ????? ????? ??????? ?????? ?????. ??? ?????? ?????? ????? ?????????? ?? ?? ??? ???? ?? ??? ????? ???? ?? ?????? ??? ?????. ???????? ??? ???? ???? ???? ????? ????? ?? "??? ???????". ??? ???? ??????:
  • ??? ??? ????? ???? MSSearch ??? ?????? ??????? SQL Server 2000 SP3 ???? ????? ??? ?????? ????:
    Event Type:	Information
    Event Source:	Microsoft Search
    Event Category:	Search Service 
    Event ID:	1003
    Date:		7/24/2002
    Time:		5:26:51 PM
    User:		N/A
    Computer:	FTS8
    Description:
    The Search service has started.
    
    
    For more information, see Help and Support Center at http://support.microsoft.com.
  • ??? ?????? ????? ?????? ?? ???? SQL Server ?? ????? ???? MSSearch ???? ?????? ?????? ??????? ???? ??? ???? ????? ???? ?????? ??????? ??? ??? ??????? ?????? MSSearch ???? ????? ??? ?????? ???:
    Event Type:	Information
    Event Source:	MssCi
    Event Category:	None
    Event ID:	4138
    Date:		7/24/2002
    Time:		5:26:51 PM
    User:		N/A
    Computer:	FTS8
    Description:
    Content index corruption detected in component CI-RcovStorageObj1 in catalog e:\ft\SQL0000800005\Build\Indexer\NlFiles. 
    Stack trace is
      0x01045027
      0x0104BE13
      0x010469E0
      0x0104D0CD
      0x01048477
      0x013BCE70
      0x013B9D9F
      0x013BA645
      0x009F4251
      0x009F450D
      0x0138CE4C
      0x0138E1D0
      0x00A32783
      0x00A2247A
      0x00A99965
      0x00AA5BDC
      0x77E8758A
    				
    For more information, see Help and Support Center at http://support.microsoft.com
    
  • ????? ????? ??? ???? ?????? MSSearch ???? ???? ??? ?? ???????? ???? ?? ??????? ?? ??? ?? ??????? ??? ????. ???? ????? ??? ??? ???????? ????? ?? ??? ????? ????? ???????. ??? ???? ????? ??????? ??? ??? ??????? ?????? MSSearch ? ?????? ????? ????? ?? ????, ???:
    Event Type:	Error
    Event Source:	Microsoft Search
    Event Category:	Indexer 
    Event ID:	7039
    Date:		7/24/2002
    Time:		5:26:51 PM
    User:		N/A
    Computer:	FTS8
    Description:
    The Content Index for project <SQLServer SQL0000800005> cannot be 
    loaded. Error: c0041821 - The content index data on disk is for the wrong version.  
    
    For more information, see Help and Support Center at http://support.microsoft.com.
  • ?? MSSearch ? ????? ????? ????? ???????. ???? ????? ????? ??? ??? ?? ???????? ?? ??? ????? ????? (? ??????? ??? ????? ?????? ????). ?? ?????? ????? ????? ?? ????? ????? ? ?????? ????? ?? ??? ????? ??? ?????, ???????? ??? ????? ???????? ??? ?? ??? ????? ? ????? ??????? ????????. ????? ????? ????? ????? ?????? ???? ?????? ??? ?????.

    ??? ???? ????? ??????? ??? ??? ??????? ?????? MSSearch ????? ????? ?? ???? ? ????? ??? ??????:
    Event Type:	Information
    Event Source:	Microsoft Search
    Event Category:	Gatherer 
    Event ID:	3041
    Date:		7/24/2002
    Time:		5:26:51 PM
    User:		N/A
    Computer:	FTS8
    Description:
    Project <SQLServer SQL0000800005> is being reset.
    
    For more information, see Help and Support Center at 
    http://support.microsoft.com.

    ??????: ??? ???????? ??????? ???? ??? ?? ???? ????? ????? ??? SQL Server 2000 SP3 ? ???? ??? "???? ??????".
  • ??? ?????? ????? ????? ????? ??? ???? ????? ?? ????? ????? ????? ????? ????? ?????? ???:
    Event Type:	Information
    Event Source:	Microsoft Search
    Event Category:	Gatherer 
    Event ID:	3018
    Date:		7/24/2002
    Time:		5:26:53 PM
    User:		N/A
    Computer:	FTS8
    Description:
    The end of crawl for project <SQLServer SQL0000800005> has been detected. The Gatherer 
    successfully processed 0 documents totaling 0K. It failed to filter 0 documents. 0 URLs could 
    not be reached or were denied access.
    
    For more information, see Help and Support Center at 
    http://support.microsoft.com.
?? ???? ???? ??? ????? ????? ????? ????? ????? ?? ???? ????? ?? ????? ????? ??????? ??????? ???? ?????? ????????.

???????

???? ???????: 327217 - ????? ??? ??????: 17/????/1428 - ??????: 5.4
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbproductlink kbinfo KB327217 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????327217

????? ???????

 

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