|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Maintenance plans not installedSQL 2005 workstation components, configuration tools, analysis services,
performance tools & management studio installed. Can't find maintenance plans. Have installed full integration services. What specifically needs to be installed in 2005 to get to maintenance plans? You have to create the maintenance plans. There are NO maintenance plans
until you create some. Right click in the Maintenance Plan window, and select [Maintenance Plan Wizard]. It will 'walk' you through the process. For more information about Maintenance Plans, see "Maintenance Plans" and "Maintenance Plan Wizard" in Books on Line. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous "RJ" <R*@discussions.microsoft.com> wrote in message news:A20DC67A-300B-4A07-A0B2-C2DFA85D8A6D@microsoft.com... > SQL 2005 workstation components, configuration tools, analysis services, > performance tools & management studio installed. Can't find maintenance > plans. Have installed full integration services. What specifically needs > to > be installed in 2005 to get to maintenance plans? I don't have a maintenance plan window - that's the problem! Sorry if I
didn't communicate that clearly. Show quote "Arnie Rowland" wrote: > You have to create the maintenance plans. There are NO maintenance plans > until you create some. > > Right click in the Maintenance Plan window, and select [Maintenance Plan > Wizard]. It will 'walk' you through the process. > > For more information about Maintenance Plans, see "Maintenance Plans" and > "Maintenance Plan Wizard" in Books on Line. > > -- > Arnie Rowland, Ph.D. > Westwood Consulting, Inc > > Most good judgment comes from experience. > Most experience comes from bad judgment. > - Anonymous > > > "RJ" <R*@discussions.microsoft.com> wrote in message > news:A20DC67A-300B-4A07-A0B2-C2DFA85D8A6D@microsoft.com... > > SQL 2005 workstation components, configuration tools, analysis services, > > performance tools & management studio installed. Can't find maintenance > > plans. Have installed full integration services. What specifically needs > > to > > be installed in 2005 to get to maintenance plans? > > > So when you click on [Management] in the Server Explorer pane, [Maintenance
Plan] is NOT listed in the right pane? -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous "RJ" <R*@discussions.microsoft.com> wrote in message news:38D1E8F6-F2B7-4A5C-A1E1-8772B3852F83@microsoft.com... >I don't have a maintenance plan window - that's the problem! Sorry if I > didn't communicate that clearly. > > "Arnie Rowland" wrote: > >> You have to create the maintenance plans. There are NO maintenance plans >> until you create some. >> >> Right click in the Maintenance Plan window, and select [Maintenance Plan >> Wizard]. It will 'walk' you through the process. >> >> For more information about Maintenance Plans, see "Maintenance Plans" and >> "Maintenance Plan Wizard" in Books on Line. >> >> -- >> Arnie Rowland, Ph.D. >> Westwood Consulting, Inc >> >> Most good judgment comes from experience. >> Most experience comes from bad judgment. >> - Anonymous >> >> >> "RJ" <R*@discussions.microsoft.com> wrote in message >> news:A20DC67A-300B-4A07-A0B2-C2DFA85D8A6D@microsoft.com... >> > SQL 2005 workstation components, configuration tools, analysis >> > services, >> > performance tools & management studio installed. Can't find >> > maintenance >> > plans. Have installed full integration services. What specifically >> > needs >> > to >> > be installed in 2005 to get to maintenance plans? >> >> >> Correct. Management displays, but maintenance plan does not show up in the
right pane. Show quote "Arnie Rowland" wrote: > So when you click on [Management] in the Server Explorer pane, [Maintenance > Plan] is NOT listed in the right pane? > > -- > Arnie Rowland, Ph.D. > Westwood Consulting, Inc > > Most good judgment comes from experience. > Most experience comes from bad judgment. > - Anonymous > > > "RJ" <R*@discussions.microsoft.com> wrote in message > news:38D1E8F6-F2B7-4A5C-A1E1-8772B3852F83@microsoft.com... > >I don't have a maintenance plan window - that's the problem! Sorry if I > > didn't communicate that clearly. > > > > "Arnie Rowland" wrote: > > > >> You have to create the maintenance plans. There are NO maintenance plans > >> until you create some. > >> > >> Right click in the Maintenance Plan window, and select [Maintenance Plan > >> Wizard]. It will 'walk' you through the process. > >> > >> For more information about Maintenance Plans, see "Maintenance Plans" and > >> "Maintenance Plan Wizard" in Books on Line. > >> > >> -- > >> Arnie Rowland, Ph.D. > >> Westwood Consulting, Inc > >> > >> Most good judgment comes from experience. > >> Most experience comes from bad judgment. > >> - Anonymous > >> > >> > >> "RJ" <R*@discussions.microsoft.com> wrote in message > >> news:A20DC67A-300B-4A07-A0B2-C2DFA85D8A6D@microsoft.com... > >> > SQL 2005 workstation components, configuration tools, analysis > >> > services, > >> > performance tools & management studio installed. Can't find > >> > maintenance > >> > plans. Have installed full integration services. What specifically > >> > needs > >> > to > >> > be installed in 2005 to get to maintenance plans? > >> > >> > >> > > > See Jasper's note below.
-- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous "RJ" <R*@discussions.microsoft.com> wrote in message news:8AC33745-D8E5-4358-85D7-4C229C7F19E5@microsoft.com... > Correct. Management displays, but maintenance plan does not show up in > the > right pane. > > "Arnie Rowland" wrote: > >> So when you click on [Management] in the Server Explorer pane, >> [Maintenance >> Plan] is NOT listed in the right pane? >> >> -- >> Arnie Rowland, Ph.D. >> Westwood Consulting, Inc >> >> Most good judgment comes from experience. >> Most experience comes from bad judgment. >> - Anonymous >> >> >> "RJ" <R*@discussions.microsoft.com> wrote in message >> news:38D1E8F6-F2B7-4A5C-A1E1-8772B3852F83@microsoft.com... >> >I don't have a maintenance plan window - that's the problem! Sorry if I >> > didn't communicate that clearly. >> > >> > "Arnie Rowland" wrote: >> > >> >> You have to create the maintenance plans. There are NO maintenance >> >> plans >> >> until you create some. >> >> >> >> Right click in the Maintenance Plan window, and select [Maintenance >> >> Plan >> >> Wizard]. It will 'walk' you through the process. >> >> >> >> For more information about Maintenance Plans, see "Maintenance Plans" >> >> and >> >> "Maintenance Plan Wizard" in Books on Line. >> >> >> >> -- >> >> Arnie Rowland, Ph.D. >> >> Westwood Consulting, Inc >> >> >> >> Most good judgment comes from experience. >> >> Most experience comes from bad judgment. >> >> - Anonymous >> >> >> >> >> >> "RJ" <R*@discussions.microsoft.com> wrote in message >> >> news:A20DC67A-300B-4A07-A0B2-C2DFA85D8A6D@microsoft.com... >> >> > SQL 2005 workstation components, configuration tools, analysis >> >> > services, >> >> > performance tools & management studio installed. Can't find >> >> > maintenance >> >> > plans. Have installed full integration services. What specifically >> >> > needs >> >> > to >> >> > be installed in 2005 to get to maintenance plans? >> >> >> >> >> >> >> >> >> SQL2005 RTM required you to install SSIS and the Management Tools in order
to use the new SSIS maintenance plans (you can still use xp_sqlmaint manually however). With SQL2005 SP1 this is no longer the case as long as you have the managment tools installed. See http://support.microsoft.com/kb/916940 and click on Maintenance plans Show quote "RJ" <R*@discussions.microsoft.com> wrote in message news:38D1E8F6-F2B7-4A5C-A1E1-8772B3852F83@microsoft.com... >I don't have a maintenance plan window - that's the problem! Sorry if I > didn't communicate that clearly. > > "Arnie Rowland" wrote: > >> You have to create the maintenance plans. There are NO maintenance plans >> until you create some. >> >> Right click in the Maintenance Plan window, and select [Maintenance Plan >> Wizard]. It will 'walk' you through the process. >> >> For more information about Maintenance Plans, see "Maintenance Plans" and >> "Maintenance Plan Wizard" in Books on Line. >> >> -- >> Arnie Rowland, Ph.D. >> Westwood Consulting, Inc >> >> Most good judgment comes from experience. >> Most experience comes from bad judgment. >> - Anonymous >> >> >> "RJ" <R*@discussions.microsoft.com> wrote in message >> news:A20DC67A-300B-4A07-A0B2-C2DFA85D8A6D@microsoft.com... >> > SQL 2005 workstation components, configuration tools, analysis >> > services, >> > performance tools & management studio installed. Can't find >> > maintenance >> > plans. Have installed full integration services. What specifically >> > needs >> > to >> > be installed in 2005 to get to maintenance plans? >> >> >> SP1 is installed according to update history and messages in event log "SP1
for SQL Server Tools & Workstations Components installed successfully". Same type of message for the SQL Server integration services sp1. Show quote "Jasper Smith" wrote: > SQL2005 RTM required you to install SSIS and the Management Tools in order > to use the new SSIS maintenance plans (you can still use xp_sqlmaint > manually however). With SQL2005 SP1 this is no longer the case as long as > you have the managment tools installed. See > http://support.microsoft.com/kb/916940 and click on Maintenance plans > > -- > HTH, > Jasper Smith (SQL Server MVP) > http://www.sqldbatips.com > > > "RJ" <R*@discussions.microsoft.com> wrote in message > news:38D1E8F6-F2B7-4A5C-A1E1-8772B3852F83@microsoft.com... > >I don't have a maintenance plan window - that's the problem! Sorry if I > > didn't communicate that clearly. > > > > "Arnie Rowland" wrote: > > > >> You have to create the maintenance plans. There are NO maintenance plans > >> until you create some. > >> > >> Right click in the Maintenance Plan window, and select [Maintenance Plan > >> Wizard]. It will 'walk' you through the process. > >> > >> For more information about Maintenance Plans, see "Maintenance Plans" and > >> "Maintenance Plan Wizard" in Books on Line. > >> > >> -- > >> Arnie Rowland, Ph.D. > >> Westwood Consulting, Inc > >> > >> Most good judgment comes from experience. > >> Most experience comes from bad judgment. > >> - Anonymous > >> > >> > >> "RJ" <R*@discussions.microsoft.com> wrote in message > >> news:A20DC67A-300B-4A07-A0B2-C2DFA85D8A6D@microsoft.com... > >> > SQL 2005 workstation components, configuration tools, analysis > >> > services, > >> > performance tools & management studio installed. Can't find > >> > maintenance > >> > plans. Have installed full integration services. What specifically > >> > needs > >> > to > >> > be installed in 2005 to get to maintenance plans? > >> > >> > >> > > > Very odd. I've never seen that or heard of it as an issue. The only thing I
can suggest is removing the management tools, reinstalling them and reapplying SP1. If that doesn't wotk then you should open a case with PSS. Show quote "RJ" <R*@discussions.microsoft.com> wrote in message news:98F1A2E1-E061-4967-BCFE-A309F85E12F9@microsoft.com... > SP1 is installed according to update history and messages in event log > "SP1 > for SQL Server Tools & Workstations Components installed successfully". > Same > type of message for the SQL Server integration services sp1. > > "Jasper Smith" wrote: > >> SQL2005 RTM required you to install SSIS and the Management Tools in >> order >> to use the new SSIS maintenance plans (you can still use xp_sqlmaint >> manually however). With SQL2005 SP1 this is no longer the case as long as >> you have the managment tools installed. See >> http://support.microsoft.com/kb/916940 and click on Maintenance plans >> >> -- >> HTH, >> Jasper Smith (SQL Server MVP) >> http://www.sqldbatips.com >> >> >> "RJ" <R*@discussions.microsoft.com> wrote in message >> news:38D1E8F6-F2B7-4A5C-A1E1-8772B3852F83@microsoft.com... >> >I don't have a maintenance plan window - that's the problem! Sorry if I >> > didn't communicate that clearly. >> > >> > "Arnie Rowland" wrote: >> > >> >> You have to create the maintenance plans. There are NO maintenance >> >> plans >> >> until you create some. >> >> >> >> Right click in the Maintenance Plan window, and select [Maintenance >> >> Plan >> >> Wizard]. It will 'walk' you through the process. >> >> >> >> For more information about Maintenance Plans, see "Maintenance Plans" >> >> and >> >> "Maintenance Plan Wizard" in Books on Line. >> >> >> >> -- >> >> Arnie Rowland, Ph.D. >> >> Westwood Consulting, Inc >> >> >> >> Most good judgment comes from experience. >> >> Most experience comes from bad judgment. >> >> - Anonymous >> >> >> >> >> >> "RJ" <R*@discussions.microsoft.com> wrote in message >> >> news:A20DC67A-300B-4A07-A0B2-C2DFA85D8A6D@microsoft.com... >> >> > SQL 2005 workstation components, configuration tools, analysis >> >> > services, >> >> > performance tools & management studio installed. Can't find >> >> > maintenance >> >> > plans. Have installed full integration services. What specifically >> >> > needs >> >> > to >> >> > be installed in 2005 to get to maintenance plans? >> >> >> >> >> >> >> >> >> RJ (R*@discussions.microsoft.com) writes:
> SP1 is installed according to update history and messages in event log By chance, you don't happen to have the Express version of SQL Server> "SP1 for SQL Server Tools & Workstations Components installed > successfully". Same type of message for the SQL Server integration > services sp1. Management Studio installed? -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx  |
|||||||||||||||||||||||
Other interesting topics