Dave Burke : Freelance .NET Web Developer specializing in Online Communities

CS Nuglet: Empty the searchbarrel before a move

As we mentioned on a recent post covering CS database shrinkage, the search data in the Community Server SQL database takes up a lot of real estate.  A lot of it.  You certainly don't need to lug it around if you're moving the database from one location to the next, so empty the searchbarrel before making a move.  The indexes will be rebuilt automatically on the other side and you saved yourself a ton of FTP wait time.


TRUNCATE TABLE cs_SearchBarrel
TRUNCATE TABLE cs_SearchIgnoreWords
UPDATE cs_Posts SET IsIndexed=0

Comments (0) | Post RSS RSS comment feed

Posted on 3/12/2007 10:07:00 AM by Dave Burke
Categories: Community Server
Tags:

Related posts


Powered by BlogEngine.NET 2.0.0.36
Theme by Dave Burke