Rebuild index maintenance plan fails.can any one please tell me wht could be the reason.below is the error message i get
-
Sunday, September 02, 2012 1:08 AM
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
- Edited by Shruthi12 Sunday, September 02, 2012 1:09 AM
All Replies
-
Sunday, September 02, 2012 1:29 AM
please use xp_readerrorlog or jobs history and paste the error,Ramesh Babu Vavilla MCTS,MSBI
- Marked As Answer by Shruthi12 Saturday, September 08, 2012 4:03 AM
-
Sunday, September 02, 2012 7:46 AMAnswerer
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
- Proposed As Answer by Rama UdayaMicrosoft Community Contributor Sunday, September 02, 2012 11:45 AM
- Marked As Answer by Shruthi12 Monday, September 03, 2012 2:01 AM

