oK, I might not have checked most of the suggestions you have aske now, but i am quite sure that this plans id is not in use by other plans,...

i have tried that and honestly the msdb tables have more than one referential integrity.

For me to succeed i need a way of write a delete script that deletes from...

i didi that first and still i get the the same error.

On SQL Management studio under Agent/Jobs/

there are schedule tasks that get executed by the agent.

Some of these jobs have been disabled for Ages. my task is to identify and clean...

This script is not working.

I even tested it by downloading northwind database from ms website and perfomed backup on it on D:\Data\.

please tel me how you would go aboput...

EXECUTE master.dbo.xp_delete_file 0,N'D:\BackupFolder',N'BAK',@DelDate, 1

LET'S SAY I WANT TO DELETE TODAYS BACKUP just to test if you script works.

send me your code.

One more thing do i put the backup and with...

And if the backup files that needs to be deleted are more than one and all of them are named using the instance_name and date, how will you go about...

I am having challenge in testing this script, im running sql2005 on win 2003 standard eddition.

What if you want to run the script every day as a job that must run after business hrs Instead of inserting a date value?

were n't there any changes on server level the past few days, e.g any upgrades, or patches?

Why don`t you try to compare the trace of this database with the trace of the similar database for a fullday operation and see if you can`t get any malicious...

One thing that is not clear to me is about setting/modifying the log file size, say maybe for in this case you have a database which growths on daily bases,...