sql server 2005 maintenance plans folder missing

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sql server 2005 maintenance plans folder missing

Author

Topic

dbthj
Posting Yak Master

143 Posts

Posted - 2007-08-10 : 15:05:59

I've seen a few threads on this which seem to suppose the problem is on Express edition rather than Standard edition. Not so here.
This is definitely Standard edition, SP3 as seen by running
SELECT CONVERT(char(20), SERVERPROPERTY('Edition'))
SELECT CONVERT(char(20), SERVERPROPERTY('ProductLevel'))
In SSMS
Under the Management folder there is no "Maintenance Plans" folder.
There IS a "Maintenance Plans" folder under the Legacy Folder.
I have another instance which is Standard and SP1 which looks just fine.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-10 : 15:12:22

so you're not running SSMS Express? the express version of client tools?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

dbthj
Posting Yak Master

143 Posts

Posted - 2007-08-10 : 16:05:54

The client was installed at the same time as the instance. They can be diffent? How can you tell if the client is Express edition?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-10 : 16:19:43

when you start it up the splash screen says SSMS Express

it's probably a bug.
don't know if it could be a permissions issue, though...

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

dbthj
Posting Yak Master

143 Posts

Posted - 2007-08-10 : 17:06:06

Nope, Nothing says SSMS Express. Doesn't say Standard either.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-11 : 00:57:06

Checked help -> about in ssms?

dbthj
Posting Yak Master

143 Posts

Posted - 2007-08-13 : 09:09:40

In SSMS, Help/About gives a window that says at the top:
About Microsoft SQL Server Management Studio.
It says, Windows Server System
It says SQL Server 2005
Table with "Component Name" and "Versions" columns.
In this table, the version for Microsoft SQL Server Management Studio is 9.00.1399.00
Then some warning verbage and an OK button.

Nothing about the Edition. No "Express". No "Standard"

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-13 : 16:10:58

What's sql2k5 sp level on that server?

dbthj
Posting Yak Master

143 Posts

Posted - 2007-08-14 : 09:59:44

This must be the deal.
Although this is SQL 2005, The databases are
all at compatability level of SQL2000, SP3.
That probably explains why the "Maintenance Plans" folder
is displayed under the "Legacy" folder, rather than under
the "Management" folder.

zhenchyld
Starting Member

1 Post

Posted - 2010-12-30 : 22:14:41

You are probably connecting to a SQL Server 2000 database engine. The usual 'Maintenance Plans' folder will not show up, and there will be other small differences you may notice, like 'Properties' will list slightly less information. Try connecting to a known SQL Server 2005 database engine instance, and the Maintenance Plan folder should now be visible. It's not a matter of your version of SSMS, it's a matter of the version of database engine.

To create a maintenance plan on your SQL Server 2000 DB engine, check if the old SQL Server 2000 Enterprise Manager is installed on the machine and do it through there.

Hope that helped :D

Andy Boyd
www.siliconrockstar.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources