Re: need help restoring search databases by callahan
callahan
Thu Jun 28 06:21:19 CDT 2007
Oaktree. You do not have to delete your databases from SQL yourself. You
just have to tell sharepoint to create a new database. When you do that,
sharepoint, as it was colloquially mentioned, will drop or disconnect from
the original search database.
In other words, you do not need to go to SQL at all. As was mentioned
previously, you only have to make changes in the Sharepoint Central
Administration site interface by going to Operations and selecting Services
on Server on the server who should be hosting the search service.
If your search service is not working, you can go to the Services on Server
page for the server hosting search, and stop the service (which causes
search to abandon it's index files and the search database). Note that I
did not say to go to SQL and delete anything. Then, if you start the
service, it will take you to a page where you need to configure search
settings in order for search to start and run successfully. On that page,
specify a domain account (assuming you are on a domain) for the search
service and a domain account for the index (content access) service. Then
you specify the new name of the search database that search will now use.
This is where the "picking up of a new database" occurs. There is no
recovering the first database. This is because the first database was
likely what was causing your problems to occur. This is why the other
poster suggested you drop it. This has been the experience of numerous
sharepoint administrators-- that occasionally the search database becomes a
problem and the problem is solved by having sharepoint make a new search
database.
After you have configured the settings, click OK to start the service with
the settings you've made.
Then wait. The index service needs to rebuild the indexes and put data in
the new search database. This will take however much time it requires based
on the amount of data in the content databases of the web applications that
are set to use that server's search service, depending on how you have
configured the schedule for indexing.
Please note Oaktree, these are just suggestions made by someone who may have
had similar problems and this is what helped them fix it. This was not
intended to force you to go do stuff in SQL. ; )
-callahan
"OakTree8" <clearvisionhr@gmail.com> wrote in message
news:1182983476.478362.232050@m36g2000hse.googlegroups.com...
>I moved my server and restored to a new one, all works but the
> search. I am using WSS 3.0.
>
> Someone on the board told me all I had to do was delete my search
> databases, drop them from SQL, delete them, and restart the search
> service to recreate them.
>
> Problem is I dont know how to do all that SQL stuff so I can delete
> them. They are in use and even if I stop services they are still in
> use?
>
> Second, will the search recreate the database after I delete them or
> do I have to manually create a search database and re-add it to SQL?
> And how if so?
>
> Help please, thanks
>