We have turned this problem over to a vendor to fix, as they broke it in the first place .

thanks.

I am running:

Microsoft SQL Server  2000 - 8.00.2040 (Intel X86)   May 13 2005 18:33:17   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: )

And that...

I was wondering the same thing - as we only create backups thorough the maintenance plan, we can presume they exist there. 

thanks alot

sam

I setup a trace on EM and found this bit of code running when you click properties of a maint plan

exec msdb..sp_help_jobstep @job_id = 0x9DDEE741CB1B5142B51549E57E0DB4DD, @step_id = 1

That is executed...

That is a great little ERD! Thanks alot.

Still, I see no link between the job and the backup it creates.  I know EM gathers parameters for the sqlmaint.exe command...

I see. Thanks for your assistance.

sam

wangkhar,

I don't see a path to disk or any way of linking to a maintenance plan there - the backup_set_uuid doesn't seem to link to plan_id in sysdbmaintplans. 

Cath,

Thanks! That...

Where I am working, a consultant used the migration wizard for dts->ssis and it has seemed to work well.  You cannot use ActiveX scripts, they must be converted to .net Script tasks,...

Thanks alot - please consider this post answered.

I read another post and a guy said he used target server memory and total server memory to see if there was enough memory to increase worker threads - they...

Thanks guys,

I'll look into the INFORMATION_SCHEMA route - seems the best.  But thanks for the foreachdb tip too!

Sam

thanks, but that is the article i was using.