April 16, 2015 at 12:59 am
Hello
I am getting below mentioned error while executing maintenance plan on my SQL server which I use for re-building indexes. This doesn't happen always. Sometimes, it works just fine.
--------------------------------------------------------------------------------
Executed as user: NSGSQL\SYSTEM. ...% complete End Progress Progress: 2015-04-04 07:46:53.73
Source: Rebuild Index
Executing query "ALTER INDEX [IF370Cad_Piece_Details] ON [dbo].[Cad_Piece_Details".: 11% complete End Progress Progress: 2015-04-04 07:46:53.73
Source: Rebuild Index
Executing query "USE [TestDB] ".: 12% complete End Progress Progress: 2015-04-04 07:46:55.11
Source: Rebuild Index
Executing query "ALTER INDEX [PK__Cad_Piece_Detail__324C5FD9] ON [d...".: 12% complete End Progress Progress: 2015-04-04 07:46:55.11
Source: Rebuild Index
Executing query "USE [TestDB] ".: 12% complete End Progress Progress: 2015-04-04 07:46:55.33
Source: Rebuild Index
Executing query "ALTER INDEX [PK__Cad_SystemIds__39ED81A1] ON [dbo]...".: 12% complete End Progress Progress: 2015-04-04 07:46:55.33
Source: Rebuild Index
Executing query "USE [TestDB] ".: 12% complete End Progress Progress: 2015-04-04 07:46:55.34
Source: Rebuild Index
Executing query "ALTER INDEX [PK__Classifier2Addre__3BD5CA13] ON [d...".: 12% complete End Progress Progress: 2015-04-04 07:46:55.34
Source: Rebuild Index
Executing query "USE [TestDB] ".: 12% complete End Progress Progress: 2015-04-04 07:46:55.36
Source: Rebuild Index
Executing query "ALTER INDEX [PK__ClassifierInfo__3FA65AF7] ON [dbo...".: 12% complete End Progress Progress: 2015-04-04 07:46:55.36
Source: Rebuild Index
Executing query "USE [TestDB] ".: 12% complete End Progress Progress: 2015-04-04 07:46:55.40
Source: Rebuild Index
Executing query "ALTER INDEX [PK__ClassifierLabels__418EA369] ON [d...".: 13% complete End Progress Progress: 2015-04-04 07:46:55.40
Source: Rebuild Index
Executing query "USE [TestDB] ".: 13% complete End Progress Progress: 2015-04-04 07:46:55.47
Source: Rebuild Index
Executing query "ALTER INDEX [IE1Classifiers] ON [dbo].[Classifiers...".: 13% complete End Progress Progress: 2015-04-04 07:46:55.47
Source: Rebuild Index
Executing query "USE [TestDB] ".: 13% complete End Progress Progress: 2015-04-04 07:46:55.53
Source: Rebuild Index
Executing query "ALTER INDEX [IE2Classifiers] ON [dbo].[Classifiers...".: 13% complete End Progress Progress: 2015-04-04 07:46:55.53
Source: Rebuild Index
Executing query "USE [TestDB] ".: 13% complete End Progress Progress: 2015-04-04 07:46:55.54
Source: Rebuild Index
Executing query "ALTER INDEX [IE3Classifiers] ON [dbo].[Classifiers...".: 13% complete End Progress Progress: 2015-04-04 07:46:55.54
Source: Rebuild Index
Executing query "USE [TestDB] ".: 13% complete End Progress Progress: 2015-04-04 07:46:55.61
Source: Rebuild Index
Executing query "ALTER INDEX [PK__Classifiers__47477CBF] ON [dbo].[...".: 13% complete End Progress Progress: 2015-04-04 07:46:55.61
Source: Rebuild Index
Executing query "USE [TestDB] ".: 13% complete End Progress Progress: 2015-04-04 07:46:56.92
Source: Rebuild Index
Executing query "ALTER INDEX [IF232CLCheckList] ON [dbo].[CLCheckLi...".: 14% complete End Progress Progress: 2015-04-04 07:46:56.92
Source: Rebuild Index
Executing query "USE [TestDB] ".: 14% complete End Progress Progress: 2015-04-04 07:47:00.62
Source: Rebuild Index
Executing query "ALTER INDEX [PK__CLCheckList__4A23E96A] ON [dbo].[...".: 14% complete End Progress Progress: 2015-04-04 07:47:00.62
Source: Rebuild Index
Executing query "USE [TestDB] ".: 14% complete End Progress Progress: 2015-04-04 07:47:02.54
Source: Rebuild Index
Executing query "ALTER INDEX [IF233CLDependency] ON [dbo].[CLDepend...".: 14% complete End Progress Progress: 2015-04-04 07:47:02.54
Source: Rebuild Index
Executing query "USE [TestDB] ".: 14% complete End Progress Progress: 2015-04-04 07:47:02.93
Source: Rebuild Index
Executing que... The package execution fa... The step failed.
---------------------------------------------------------------------------------------
Can anybody help me about this? Where can I check for cause of error?
April 16, 2015 at 1:53 am
Maintenance plans suck:
1) No appropriate logging
2) Rebuild indexes that are not fragmented enough
3) Rebuild indexes that are too small to benefit from rebuild
I strongly recommend that you stop using maintenance plans and switch to Ola Hallengren's maintenance solution. You can find it here: http://ola.hallengren.com
-- Gianluca Sartori
April 16, 2015 at 6:08 am
Or, check out Minion Reindex which is available here[/url].
Assuming your maintenance plan is being run by SQL Agent, you can try outputing everything from Agent to a file. It's a setting on the Job inside SQL Agent. Make the change there. You might be able to get a more complete error message there.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply