DCSIMG
MOSS search issues with SQL rebuild indexes - itaysk

MOSS search issues with SQL rebuild indexes

Posted Wednesday, March 28, 2007 9:55 AM by Itay Shakury

It's an often DBA task to rebuild indexes for a database as part of a maintenance plan, but watch out! MOSS search DB's don't like it!

This post explains it all: http://blogs.vertigo.com/personal/michael/Blog/Lists/Posts/Post.aspx?ID=4

And some official word from the Knowledge Base: http://support.microsoft.com/kb/930887/en-us

I've read somewhere that SQL SP2 fix this (can't recall where), can someone confirm this?

 

Comments

# re: MOSS search issues with SQL rebuild indexes

Wednesday, March 28, 2007 1:42 PM by Adlai Maschiach

SQL Server 2005 sp2 and maintenance plan (bug)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1366170&SiteID=1

please , next time , look if someone has posted an article about the subject before posting another one 1 hour later

# re: MOSS search issues with SQL rebuild indexes

Sunday, April 01, 2007 3:13 PM by Itay Shakury

I'm sorry but I can't see how this post has something to do with mines. I'm talking on the effect the 'rebuild index' operation has on MOSS search DB in particular.

Leave a Comment

(required) 
(required) 
(optional)
(required) 

Enter the numbers above: