Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SQL question

  Asked By: Salvatore    Date: Nov 10    Category: Sharepoint    Views: 651

I have a test portal up, just seeing what I can make and break while
not posing any threat to the company since it's really not up "live"

I've been toying around with the SQL tables, and have found that if
you delete a site DIRECTLY off SQL Server, it somehow still seems to
show up in search results. I know that it's like taboo to directly
work with the tables...but is this something that I can't get away
from? or is there a way to remove the site from showing up in
search results?



3 Answers Found

Answer #1    Answered By: Dante Parsons     Answered On: Nov 10

If you are using Sharepoint portal  Server, you need to make sure that
the search  indexes are being refreshed.

Out of the box, the indexing may not refresh for a few hours.

Go to Site Settings

Configure Search and Indexing

Manage Search Schedule

Make sure a schedule is set to crawl the content.

Answer #2    Answered By: Luke Davis     Answered On: Nov 10

You may also have to reindex from scratch after emptying the content

-Go to site  settings
-Then to Configure search  and indexing
-Enable advanced mode if this isn't already done (warning, one time
operation can't go back).
-Under content indexes click manage
-Find the portal  content index and reset it
-Run a full update.

That should remove  any ghosts.

Answer #3    Answered By: Daniella Landry     Answered On: Nov 10

You should never directly  modify the SQL database this can cause unknown
problems with your Sharepoint server.

If you want to remove  a site  from being indexed then you go into the
Search settings Manage crawls of the site directory and remove the sites
you don't want to index. Or you can add an exclusion in the index
settings so that it excludes that site.

I don't have SPS in front of me at the moment so i cannot provide more
details on where the settings are.

Didn't find what you were looking for? Find more on SQL question Or get search suggestion and latest updates.