Incomplete Site Databases



Hello,

We have an interesting situation on our server. The portal sites run
fine and the sub sharepoint services sites run fine. The only issue is
that search doesn't work on the services sites, such as
http://web/sites/accounting, though they work correctly from the portal
site. I know that they use two different searching structures.

Where the issue comes into play is that there is no full-text catalog
in the Web_SITE database. Also, the Docs table was missing the
Extension column for some reason. I was able to create that column and
set the correct properties on it.

When I try to create a full-text index, the SQL error logs report an
error along the lines of " The component 'MSFTE.DLL' reported error
while indexing. ". The database server is Windows Server 2003 x64 with
SQL Server 2005 x64.

My thoughts are that the database is corrupt and pretty much beyond
salavage to fix the searching issues. If I create a new portal site,
the databases are initialized correctly and searching seems to work.
Is there a way to migrate the data from this bad site into a new one
without losing any of the content / formatting or is there a way to
somehow repair the complete db structure while preserving the site
itself?

.



Relevant Pages

  • Re: Incomplete Site Databases
    ... Hum hum, sounds not good. ... create a new database in you virtual server ... We have an interesting situation on our server. ... I know that they use two different searching structures. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Combining FTS and Index Server
    ... I suspected something like that as often the database server is separate ... Fore storing a large number of files in SQL Server as the Terra Server does, ... > was not the best choice for searching, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: [PHP] Remote MySQL connection via PHP file
    ... I've been searching around for a while, ... I need to keep the connection information to a MySQL server database on another server. ...
    (php.general)
  • Location of Crawl Log - MOSS2007
    ... searching for an answer to this question and didn't have any luck... ... Is it a flat file somewhere on the server, ... I have looked through the hard drives van de server, ... access the database tables to check whether the information resides ...
    (microsoft.public.sharepoint.portalserver)
  • RE: adding another portal site
    ... I created more portal sites by first creating a corresponding Virtual Server in IIS. ... If the server farm is not part of a shared services ... Caution Incorrectly editing the registry may severely ...
    (microsoft.public.sharepoint.portalserver)

Loading