September 18, 2008 at 4:43 am
Hi Friends,
I have created maintenance plan to rebuild index, check database integrity and cleanup history.but when i try to execute this plan it gives error
Please help me for this error which is given below:
Executed as user: SQDKKRO02\SYSTEM. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 08:57:37 Progress: 2008-09-18 08:57:42.38 Source: {6CC05EE3-5C89-4195-8AA6-C8CF69DB218D} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2008-09-18 09:20:08.29 Source: Rebuild Index Executing query "USE [OperationsManager] ".: 0% complete End Progress Progress: 2008-09-18 09:20:08.37 Source: Rebuild Index Executing query "ALTER INDEX [PK_AemAppBucketInfo] ON [dbo].[AemApp".: 0% complete End Progress Progress: 2008-09-18 09:20:08.37 Source: Rebuild Index Executing query "USE [OperationsManager] ".: 0% complete End Progress Progress: 2008-09-18 09:20:08.40 Source: Rebuild Index Executing query "ALTER INDEX [PK_AemCrashCounters] ON [dbo].[AemCra".: 0% complete End Progress Progress: 2008-09-18 09:20:08.40 ... The package execution fa... The step failed.
Thanks in advance,
Shikha
September 18, 2008 at 12:21 pm
never use maint plans myself - always self code. Could be you've ticked the box which is/was fix problems if found - this always used to give problems in 7.0 and 2000. Split you steps out and run each manuallly to find the problem.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply