Thanks Very Much Greg

Jim

Thanks George

Jim

Hi Shawn

I made a copy of the maint plan that was having issues as you suggested and fixed the schedule

took me a while to straighten out all the constraint lines...

Thanks Shawn

That seems to work but is there anyway to copy the schedule as well

Thanks

Jim

Hi Folks

I thought I had resolved this 0xC001000A issue but I am still getting SQL Agent Error

even though the Plan finishes and does my backups, so i do not understand...

Thanks Lynn

Jim

Thanks Greg

Jim

Hi Martin

okay...that sounds good

will give it a shot

appreciate the assist

Jim

Hi Mark

thank for the insight

I have not figured out how to NOT DO a Diff at the same time i do my Fulls

i have Fulls scheduled for 12:00am every night...

FYI

I finally figured out the problem when i ran the Maint Plan manually. Gave me a better message:

TITLE: Execute Maintenance Plan

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

Execution failed. See the maintenance plan and SQL Server Agent...

Hi Guys

thanks for the advice

I am able to modify the original maint plan and save it

I am going to try and execute it manually from SSMS and see if it...

HI folks

found some more info, but not sure what it means:

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,

Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

10/04/2009 23:00:00,MP-FullBackup-UserDB.Subplan_1,Error,0,NSAB-SS80-SQL-N,

MP-FullBackup-UserDB.Subplan_1,(Job outcome),,The job failed.

The Job was...

Hi Ten Centuries

guess so

luckily that was my test

i think i will leave the production one alone

Jim

Hi homebrew01

wish it were that simple

Recurring and enabled every day of every week at 11:00pm

Thank

Jim