Hi Chris

some more info

database in question was deleted on 6-3-11

job(s) associated with database were deleted on 7-11-11

errors ocurred on 7-12-11

errors have not ocurred since

there are no such entries under these...

Hi Steve

thanks

I had been looking at them when I was emailing Brent Ozar a while back

He also recommened her scripts

Jim

If you are going to ask for statistics of any nature, can you plese be specific on what those statistics are based on ? e.g. "data sizes instead...

Thanks Elliot

I did not want to do that as I have added a lot of Notifications and T-SQL to the plans

What really bugs me is that the Differential plan...

Hi Steve

i agree, but until I can get there myself, I need to rely on these Maint Plans

It seems to me that something so basic should work correctly

This is just...

Hi Chris

thanks, but i do not want to delete the maint plan as I am using it everyday

the plan runs but generates a message complaining that a database does not...

H ielliot

apparently my reply did not go throuigh last week

How many subplans are in our maintenance plan?

1

it does dbcc, rebuild index, full backup

Do you have explicit databases selected in...

ok

thanks again

jim

Hi Elliott

just a follow-up

looking through the file

I found the line you were referring to:

<DTS:Property DTS:Name="ConnectionString">server='NSAB-SS80-SQL-N';Trusted_Connection=true;Application Name='Microsoft SQL Server Management Studio';Pooling=false;Packet Size=4096;multipleactiveresultsets=false;</DTS:Property></DTS:ConnectionManager></DTS:ObjectData></DTS:ConnectionManager>

Do I also need to change these other three lines...

Thanks Elliott

i will give it a shot

Jim

My followup question is there are no members in any of these groups, so should there be ?

Thanks

Jim

All is well

i changed the location

it needed a filename as well as a location

i thought it would create the filename...da....

Jim

Well .... I guess I should have known that something this simple with Microsoft was not going to work that easily. Seems I have a permissions issue, but I do...

Hi George

thanks for the quick response

Jim

FYI

after reading several like issues with SQL Server 2008 R2 i added who I was logged in as (Administrator) to these Local Security Settings which had nothing in them

Start->Run-secpol.msc

Select...