November 4, 2010 at 10:53 am
SQL Server 2005, Windows Server 2003, Standard Edition, Service Pack 2
While in Management Studio I can create a Maintenance Plan but there is no option available to create a subplan. I tried creating the maint plan manually and with the wizard but the option to create a subplan is not available. Anyone have ideas that may help?
November 4, 2010 at 11:08 am
I must be confused by what you are saying as I have multiple Maintenance Plans in SQL Server 2005 where I created multiple Subplans. If you are in the Maintenance Plan, on the upper left corner there is a "Add Subplan" icon, is this not what you are looking for?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 4, 2010 at 11:15 am
That's my problem - I know exactly the icon you are talking about as I have used it on our other servers. But on the current server that SQL Server 2005 was just installed that icon does not show up. That's why I said I don't even have an option available to create a subplan. I have googled this issue and have seen others have same issue but noone seems to have a solution. Thanks for replying.
November 4, 2010 at 11:19 am
May I ask what SP you are running, there was a bug on Maintenance Plans prior to SP2 on SQL 2005
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 4, 2010 at 11:20 am
SP2
November 4, 2010 at 11:22 am
One more question than I will bow to the higher powers - is this happening on the actual server or when you are attempting to create a subplan via your workstation? If via your workstation, are the SQL tools also at SP2 or higher?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 4, 2010 at 11:26 am
I am using Remote Desktop to connect to the actual server from my laptop.
November 4, 2010 at 1:25 pm
JohnWSmith (11/4/2010)
SQL Server 2005, Windows Server 2003, Standard Edition, Service Pack 2
The wording makes it appear that Windows is SP2, not SQL
November 4, 2010 at 1:32 pm
Good catch - please run the following in SSMS
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Results need to be SQL Server 2005 Service Pack 2 2005.90.3042 or higher
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 4, 2010 at 1:41 pm
Ran below Query:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Result:
9.00.1406.00RTMDeveloper Edition (64-bit)
Ran below Query:
SELECT @@VERSION
Result:
Microsoft SQL Server 2005 - 9.00.1406.00 (X64) Mar 3 2007 19:53:24 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Thanks
November 4, 2010 at 1:45 pm
That's it, you are currently running SQL Server 2005 RTM - no service packs have been applied. If you would like to see all available versions, updater, service packs available for SQL Server 2005, please review the following link
http://sqlserverbuilds.blogspot.com/
Once you apply SP 2 or higher, your issue should be resolved.
Have a great day,
Chris
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 4, 2010 at 1:49 pm
Thank you. I'll try this tomorrow and advise. All this is new to me. Hope I did not mislead.
November 4, 2010 at 1:53 pm
No worries, I am just glad homebrew01 caught the obvious oversight on my part. That has always been one of SQLs most annoying statements, @@version gives only the build name.
Good luck
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
November 4, 2010 at 2:11 pm
SP3 is the most recent version for SQL.
November 5, 2010 at 11:03 am
I installed SQL Server 2005 SP3 and now I'm able to create subplans. Thanks to all!!
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply