December 27, 2007 at 2:10 am
Hello,
I don't know the exact meanings of these Maintenance Plans icons and cannot find any documents talking about them on the Web.
Can you tell me ?
Or can you suggest some links or web sites talking about these Maintenance Plans icons ?
December 28, 2007 at 3:18 am
I'm at a bit of a loss to know exactly what you're asking. The maint plans are for making database and database transaction log backups - you must know what these are?
I don't actually use the builtin maint plans myself - I write my own.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 28, 2007 at 3:23 am
Hello, please open my attached Word documents, then you can see SQL Server will assign different icons to my Maintenance Plans (I have several servers).
I want to know the exact meanings of these icons.
Do you know them ?
December 28, 2007 at 5:27 am
no sorry, as I say, I don't use maint plans.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 28, 2007 at 9:53 am
They are probably based on the plan contents or possibly could these be master/target plans? Maybe one's a subplan?
Is there something different about the plans?
December 28, 2007 at 6:16 pm
Dear Steve,
My Maintenance Plans can work properly but I just want to know the actual meanings of the icons.
Up to now, I haven't found any Microsoft official documents talking about these icons.
December 29, 2007 at 12:27 pm
They are just icons for the maintenance plan. They have no special meaning.
The difference can be explained by looking at the version of SQL Server you are connecting to. I bet one is SP1 (or less) and the other is SP2 or greater.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 30, 2007 at 6:53 pm
Dear jeff.williams.3188,
What you said seems correct.
I found all my SP1 2005 servers have the yellow Maintenance Plan icons while all the SP2 machines have the red icons.
Thanks a lot.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply