I had the same or very similar issue:

In a vanilla maintenance plan:

1. backup database

2. delete backups > x days old

The maintenance plan history showed all 'good'. BUT... old backups were...

You can construct an SSIS package from Management Studio to accomplish your goal; remember to schedule the associated Agent Job.

To save time and system resources you may want to...

We were suffering from a similar issue. I had a standard-issue maintenance plan in place to check db integrity, perform the backup and delete bak files that are > 2...

We're encountering the same situation. A colleague found this item which seems offer a good explanation.

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/17/10-0-plan-cache-flush.aspx

You're right, it is a bit of a hide-n-seek challenge...

start -> programs -> SQL Server Business Intelligence Development Studio

File -> Recent Projects

- or -

File -> Recent Files

I had to do something similar to monitor a variety of field SQL Server nodes that I have very limited access to.

I created an SSIS routine on one of my...

I don't think the Maintenance Plan (ie: job metadata) gets transferred with it's job(s) though..

Hi Rob,

Sorry for my delay. Here is a sp that I use to notify me when individual datafiles are > 70% full. I call the sp from an Agent job...

Storage may have upper limits. Also in our DW I've split things out into logical filegroups to aid with performance and recovery. I've split out file groups as follows:

1....

I created an sp as follows that checks for backup history, minus anything in an exclude list and then emails the result set to our monitoring email account. Maybe this...

Hi Leeza,

Thanks tonnes for your response !

What is the difference between 'Rebuild Index' and 'Reorganize Index' ? I can't turn anything up in BOL (meaningful to my anyway).

Regarding Maintenance Cleanup...

I created the following script to show all principals and their roles and object permissions. The old standby Sql 2k stored procedures are no longer recommended by MS for such...

Hi Mohammed,

thanks for your reply. I didn't want to remove log shipping, merely temporarily disable it in preparation for a planned network outage.

I found the problem:

While I disable the log...

That is correct syntax w/ Oracle too.

Hi Anand,

If you are using SQL Server 2005, you can view log shipping status as follows:

1. in the object Explorer pane, highlight the appropriate instance

2. in the summary pane, select...