Rebuild index maintenance plan fails.can any one please tell me wht could be the reason.below is the error message i get

Question

The Rebuild index maintenance plan  which runs weekly fails with the following error

-----------------------------------------------------------------------------

Message
Executed as user: SPOITDOMAIN\spio_sqlsvr. ....4000.0 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started:  2:45:01 AM  Progress: 2012-08-26 02:45:03.27     Source:
{A173F42F-BA7A-449C-827E-E136FDD92AD9}      Executing query "DECLARE
@Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp...".: 100% complete  End
Progress  Progress: 2012-08-26 02:48:18.08     Source: Rebuild Index
   Executing query "USE [BAMArchive]  ".: 3% complete  End Progress
Progress: 2012-08-26 02:48:18.81     Source: Rebuild Index
Executing query "ALTER INDEX [PK__bam_AS2I__FBDF78C94F7CD00D] ON
[d...".: 7% complete  End Progress  Progress: 2012-08-26 02:48:18.81
  Source: Rebuild Index      Executing query "USE [BAMArchive]  ".:
10% complete  End Progress  Progress: 2012-08-26 02:48:18.84
Source: Rebuild Index      Executing query "ALTER INDEX
[PK__bam_AS2M__FBDF78C95AEE82B9] ON [d...".: 14% complete  End
Progress  Progress: 2012-08-26 02:48:18.85     Source: Rebuild Index
   Executing query "USE [BAMArchive]  ".: 17% complete  End Progress
Progress: 2012-08-26 02:48:18.87     Source: Rebuild Index
Executing query "ALTER INDEX [PK__bam_AS2M__FBDF78C95535A963] ON
[d...".: 21% complete  End Progress  Progress: 2012-08-26 02:48:18.87
   Source: Rebuild Index      Executing query "USE [BAMArchive]  ".:
25% complete  End Progress  Progress: 2012-08-26 02:48:18.89
Source: Rebuild Index      Executing query "ALTER INDEX
[PK__bam_Batc__FBDF78C938996AB5] ON [d...".: 28% complete  End
Progress  Progress: 2012-08-26 02:48:18.89     Source: Rebuild Index
   Executing query "USE [BAMArchive]  ".: 32% complete  End Progress
Progress: 2012-08-26 02:48:18.92     Source: Rebuild Index
Executing query "ALTER INDEX [PK__bam_Batc__FBDF78C93E52440B] ON
[d...".: 35% complete  End Progress  Progress: 2012-08-26 02:48:18.93
   Source: Rebuild Index      Executing query "USE [BAMArchive]  ".:
39% complete  End Progress  Progress: 2012-08-26 02:48:18.94
Source: Rebuild Index      Executing query "ALTER INDEX
[PK__bam_Busi__FBDF78C949C3F6B7] ON [d...".: 42% complete  End
Progress  Progress: 2012-08-26 02:48:18.95     Source: Rebuild Index
   Executing query "USE [BAMArchive]  ".: 46% complete  End Progress
Progress: 2012-08-26 02:48:18.96     Source: Rebuild Index
Executing query "ALTER INDEX [PK__bam_Func__FBDF78C932E0915F] ON
[d...".: 50% complete  End Progress  Progress: 2012-08-26 02:48:18.96
   Source: Rebuild Index      Executing query "USE [BAMArchive]  ".:
53% complete  End Progress  Progress: 2012-08-26 02:48:18.99
Source: Rebuild Index      Executing query "ALTER INDEX
[PK__bam_Func__FBDF78C9276EDEB3] ON [d...".: 57% complete  End
Progress  Progress: 2012-08-26 02:48:18.99     Source: Rebuild Index
   Executing query "USE [BAMArchive]  ".: 60% complete  End Progress
Progress: 2012-08-26 02:48:19.00     Source: Rebuild Index
Executing query "ALTER INDEX [PK__bam_Inte__FBDF78C92D27B809] ON
[d...".: 64% complete  End Progress  Progress: 2012-08-26 02:48:19.01
   Source: Rebuild Index      Executing query "USE [BAMArchive]  ".:
67% complete  End Progress  Progress: 2012-08-26 02:48:19.04
Source: Rebuild Index      Executing query "ALTER INDEX
[PK__bam_Inte__FBDF78C921B6055D] ON [d...".: 71% complete  End
Progress  Progress: 2012-08-26 02:48:19.05     Source: Rebuild Index
   Executing query "USE [BAMArchive]  ".: 75% complete  End Progress
Progress: 2012-08-26 02:48:19.07     Source: Rebuild Index
Executing query "ALTER INDEX [PK__bam_Rese__FBDF78C9164452B1] ON
[d...".: 78% complete  End Progress  Progress: 2012-08-26 02:48:19.07
   Source: Rebuild Index      Executing query "USE [BAMArchive]  ".:
82% complete  End Progress  Progress: 2012-08-26 02:48:19.09
Source: Rebuild Index      Executing query "ALTER INDEX
[PK__bam_Rese__FBDF78C91BFD2C07] ON [d...".: 85% complete  End
Progress  Progress: 2012-08-26 02:48:19.09     Sour...  The package
execution fa...  The step failed.

Thanks

Shruthi

Answer 1

please use xp_readerrorlog or jobs history and paste the error,

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

I would avoid using MP for such tasks. Please take a look into Ola's great script I have been using for years without problems.

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance