We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Job runing DB Maintenence Plan Failed

Medium Priority
1,080 Views
Last Modified: 2012-06-21
Hi Guys..

I have created a DB Maintenance Plan which does the basic Maintenance i.e., Reorganizing Indexes, Cleans Up history, Integrity Checks, Shrinks DB and takes a Full back up of System DB ... I do not why the Job is failing with the Below Error Msg... Please Help


 Date            2/19/2009 12:46:51 AM
Log            Job History (DB MaintenancePlan - ALL System Databases)

Step ID            1
Server            XXXX
Job Name            DB MaintenancePlan - ALL System Databases.Plan
Step Name            Plan
Duration            00:00:09
Sql Severity            0
Sql Message ID            0
Operator Emailed            
Operator Net sent            
Operator Paged            
Retries Attempted            0

Message
Executed as user: XXXX. ...rsion 10.0.1600.22 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:46:51 AM  Progress: 2009-02-19 00:46:51.76     Source: {8BEDED3B-87B7-416B-A88A-4CF954B478E9}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp...".: 100% complete  End Progress  Progress: 2009-02-19 00:46:52.09     Source: Check Database Integrity      Executing query "USE [master]  ".: 50% complete  End Progress  Progress: 2009-02-19 00:46:53.99     Source: Check Database Integrity      Executing query "DBCC CHECKDB(N'master')  WITH NO_INFOMSGS  ".: 100% complete  End Progress  Progress: 2009-02-19 00:46:54.01     Source: Check Database Integrity      Executing query "USE [model]  ".: 50% complete  End Progress  Progress: 2009-02-19 00:46:54.37     Source: Check Database Integrity      Executing query "DBCC CHECKDB(N'model')  WITH NO_INFOMSGS  ".: 100% complete  End Progress  Progress: 2009-02-19 00:46:54.38     Source: Check Database Integrity      Executing query "USE [msdb]  ".: 50% complete  End Progress  Progress: 2009-02-19 00:46:55.49     Source: Check Database Integrity      Executing query "DBCC CHECKDB(N'msdb')  WITH NO_INFOMSGS  ".: 100% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 1% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [PK__DTA_inpu__C9F492706CC31A31] ON [d...".: 3% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 5% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [PK__DTA_outp__C9F492707C055DC1] ON [d...".: 6% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 8% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [DTA_progress_index] ON [dbo].[DTA_pro...".: 10% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 11% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [DTA_reports_column_index] ON [dbo].[D...".: 13% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 15% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [PK__DTA_repo__1AA1422F316D4A39] ON [d...".: 16% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 18% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [DTA_reports_database_index] ON [dbo]....".: 20% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 21% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [PK__DTA_repo__2C9BE40F049AA3C2] ON [d...".: 23% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 25% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [DTA_reports_indexindex] ON [dbo].[DTA...".: 26% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "USE [msdb]  ".: 28% complete  End Progress  Progress: 2009-02-19 00:46:58.27     Source: Reorganize Index      Executing query "ALTER INDEX [DTA_reports_indexindex2] ON [dbo].[DT...".: 30% complete  End Progress  Progress: 2009-02-19 ...  The package execution fa...  The step failed.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Drop individual steps and run manually to see which step fails. When you find which step fails, remove it and put it in it's own maintenance plan to run after then other one. If it still fails, come back here and post the error message.

Lee

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Commented:
Is there a chance that you are running out of disk space where the .mdf and .ldf files are stored?

1. Create an error logging file in the corresponding job step for this maintenance plan (should be available under Advanced/Options tab in job step)

2. Execute the job

3. Check the log file searching on the pattern 'error'

This will give you an indication of what's wrong.. Post the error here if you cannot determine the reason or cause..

Author

Commented:
Thanks for the Suggestions guys.. The Error occured while I was trying to compress the system Databases...

Commented:
Why on earth would you want to compress the system databases?

Author

Commented:
That was a real blunder which i realised later On ...
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.