Bear in mind that with your current build you could experience problems with  cleanup tasks...

see http://www.sqlservercentral.com/columnists/sjones/2960.asp for build details.

and  http://support.microsoft.com/kb/933508/

All depends upon when you downloaded and installed SP2.  I wonder...

I'll try it tomorrow when i'm back at work and let you know.  I wish this tech. doc. was available when I needed to migrate our plans!

What build of SQL...

Hi Rocky,

Is server1 running SQL 2000 or SQL 2005? If both servers are running SQL 2005 then you can easily copy maintenance plans between servers/instances using SSIS.  If server1 is...

It's alright panic over!

When I created the plan I had managed to muddle the precedence constraints between the notify operator task & Maintenance Cleanup task... all sorted.

What's this I hear you...

Agree with David, we are currently sitting at build 3054 for all our SQL 2005 installations after applying kb934458 and haven't had any problems since it's release.

We are now reluctant...

Ok, having removed them from the dbo.sysdtspackages90 table they no longer appear under Maintenance Plans.

thanks deepak for you help.

I can see both maintenance plans listed under dbo.sysdtspackages90 not sure if I should try and delete them from this table?

All the SQL Agent jobs have been removed, I just have the 2 maintenance plans listed under Management, Maintenance Plans.  If I try and delete these then I get the...

Thanks Deepak, i've removed them from sysmaintplan_subplans but there are no references to these plans under sysmaintplan_log.  However, they are still appearing under Maintenance Plans in SSMS.

Do you know which table/s...

Thanks Deepak, i've removed them from sysmaintplan_subplans but there are no references to these plans under sysmaintplan_log.  However, they are still appearing under Maintenance Plans in SSMS.

Do you know which table/s...

Thanks Colin/Sugesh for your replies... we've already decided to up the amount of virtual memory allocated to each instance and will allow SQL to manage memory dynamically.

Cheers,

Mark

Thanks Marcus... just looking at SQLPing v3 now.

Let's hope William that doesn't happen!

But tell me, why did you move away from Backup Exec?

Consolidation!  As simple as that.  We now have a VMware environment with EMC SAN storage which is backed up by...

lol, very true!