maintenance plan reindex is failing

[swoodring]

I am in process of moving my SQL server over to SQL 2005. I am doing a side by side. I have restored it to SQL 2005. Most thing appear ok. Last night I set up a maintenance plan to re-index. It failed but gives no reason. If I view job history. I see where it starts re-indexing and re-indexed quite a few files but at bottom I see it failed but gives me no indication of why.

Here is what I see when I view history of job. It gives me no indication of why it failed. Any ideas?
Executed as user: . ...B".: 5% complete End Progress Progress: 2008-02-25 21:19:15.28 Source: Rebuild Index Task Executing query "USE [PBDSS] ".: 6% complete End Progress Progress: 2008-02-25 21:19:15.30 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_Class] ON [dbo].[Class] REBUILD WI".: 6% complete End Progress Progress: 2008-02-25 21:19:15.30 Source: Rebuild Index Task Executing query "USE [PBDSS] ".: 6% complete End Progress Progress: 2008-02-25 21:19:15.31 Source: Rebuild Index Task Executing query "ALTER INDEX [PK_Color] ON [dbo].[Color] REBUILD WI".: 7% complete End Progress Progress: 2008-02-25 21:19:15.31 Source: Rebuild Index Task Executing query "USE [PBDSS] ".: 7% complete End Progress Progress: 2008-02-25 21:19:15.34 Source: Rebuild Index Task Executing query "ALTER INDEX [IX_LastYrCurWeekLastTran] ON [dbo].[C".: 8% complete End Progress Prog... The package execution fa... The step failed.

 

[mrdenny]

How are you doing the re-index? Are you using a SQL 2005 maintenance plan, normal T/SQL, etc?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog