Re: Can we use Index Rebuild Maintenance task to defrag indexes for BizTalk Databases?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Can we use Index Rebuild Maintenance task to defrag indexes for BizTalk Databases? › Re: Can we use Index Rebuild Maintenance task to defrag indexes for BizTalk Databases?

September 23, 2009 at 5:10 AM #23295
community-content

    Re-indexing should be done only during down times, and the bts_rebuildindexes stored procedure is the only supported way to rebuild BizTalk indexes.

    Running the bts_rebuildindexes is only supported during down-time, meaning no BizTalk Server processes should be running or any isolated adapters running.

     

    Manuel Stern