Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server 2005 Maintenance plans

Status
Not open for further replies.

theoryofben

IS-IT--Management
Aug 25, 2001
149
US
Hello,

I am trying to set up a multi server maintenance plan. But I do not seem to have the options in the designer that all of the instructions say I should. The server I'm on is configured as the MSX server and I'm running SP2.

Microsoft's instructions state that I should see "subplan_1" created by default, I see no mention or options for subplans in my design tab. I also don't see the "Servers" option they say I should see. Am I missing something? I feel pretty stupid because this is pretty basic and I've spent all morning looking for it.

Any help would be appreciated.
Thanks

________________________________________________
[sub]"I have not failed. I've just found 10,000 ways that won't work."-Thomas Edison[/sub]

 
Disregard.

I figured out that the version of management studio on my local machine is only sp1, so it does not have the changes that allow me to do what I need. I just connected to the server via terminal services and have the options I need.



________________________________________________
[sub]"I have not failed. I've just found 10,000 ways that won't work."-Thomas Edison[/sub]

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top