ISBTECH
asked on
No "maintenance" folder in SQL management studio
hi all,
I've just built a new SQL server running windows 2008 server and SQL 2005. I upgraded to service pack 3 and moved my database over to the new server fine but I'm now trying to set up maintenance plans and the folder is missing. I've looked around and everything I can find on this problem seems to be about people running SQL express but this is the full SQL server. The SQL server agent service is running and I went ahead are reinstalled the Integration Services but still no go.
Any Ideas where I go next?
I've just built a new SQL server running windows 2008 server and SQL 2005. I upgraded to service pack 3 and moved my database over to the new server fine but I'm now trying to set up maintenance plans and the folder is missing. I've looked around and everything I can find on this problem seems to be about people running SQL express but this is the full SQL server. The SQL server agent service is running and I went ahead are reinstalled the Integration Services but still no go.
Any Ideas where I go next?
It is called Management... and under it there is Maintenance Plans
In Management Studio, can you click on Help, and then About, and take a print screen.
It sounds like it's management studio express.
It sounds like it's management studio express.
ASKER
Yes I am only missing the maintenance folder, everything else shows up fine.
Are the databases running in compatability level of SQL2000
Can you check the folders under Legacy ?
Can you check the folders under Legacy ?
ASKER
Here you go... As you can see my old (now DR) server has the folder on the same management studio install but the new server does not.
Humpdy,
Yes they are running in compatablility mode 80 but the DR environment is as well and that works fine.
ISBTECH-374549.flv
Humpdy,
Yes they are running in compatablility mode 80 but the DR environment is as well and that works fine.
ISBTECH-374549.flv
and the SQL Server Serice restarted with no issues after the SP 3 install
ASKER
Yes and when I ran
SELECT SERVERPROPERTY('productver sion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
it returns SP3.
SELECT SERVERPROPERTY('productver
it returns SP3.
have a read of this, interesting
http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/fe4c5bbb-ff74-4278-a0fc-f226b8c41059/
http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/fe4c5bbb-ff74-4278-a0fc-f226b8c41059/
>>SELECT SERVERPROPERTY('productver sion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
it returns SP3.<<
Please post all the output, not just one column.
it returns SP3.<<
Please post all the output, not just one column.
ASKER
That is interesting, thing is this is a brand new install. I just backed up the database and used it to create a new one on this server. No upgrade at all. Plus the msdb.dbo.sysdtspackagefold ers90 table they refer to doesn't even exist in the MSDB database. Also I just checked widows update to make sure I got all the updates and it's showing SP3 needed. I'm going to re-install that and see what happens.
ASKER
9.00.4053.00 SP3 Standard Edition
have you installed SSIS ?
The
Maintenance Plan Wizard (and the interface to plans from SMSS) is part of
SSIS. Install SSIS from the SQL Server CD and you should get it working.
Maintenance Plan Wizard (and the interface to plans from SMSS) is part of
SSIS. Install SSIS from the SQL Server CD and you should get it working.
ASKER
Yes, see below the report from "Add remove Programs":
ISB-INTSQL1
The following components are installed on this server
MSSQLSERVER
Database Engine
[Version: 9.3.4035.00 Edition: Standard Edition Patch level: 9.3.4053 Language: English (United States)]
Common components
Integration Services
[Version: 9.3.4035.00 Edition: Standard Edition Patch level: 9.3.4035 Language: English (United States)]
Workstation Components
[Version: 9.3.4035.00 Edition: Standard Edition Patch level: 9.3.4035 Language: English (United States)]
ISB-INTSQL1
The following components are installed on this server
MSSQLSERVER
Database Engine
[Version: 9.3.4035.00 Edition: Standard Edition Patch level: 9.3.4053 Language: English (United States)]
Common components
Integration Services
[Version: 9.3.4035.00 Edition: Standard Edition Patch level: 9.3.4035 Language: English (United States)]
Workstation Components
[Version: 9.3.4035.00 Edition: Standard Edition Patch level: 9.3.4035 Language: English (United States)]
is the ssis service started ?
ASKER
Yes and set to automatic.
can you connect to the Server from a different machine using Management Studio ? Do you see the folder in there ?
ASKER
Yes I can, I'm using management studio from my workstation and can see it fine. I can connect to the old server and see the folder, and the new server without the folder at the same time.
so weird !!
found this on google.
I found a solution
use msdb
Verify that the folder is missing:
exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfo lder] @P1, @P2',N'@P1
nvarchar(17),@P2 uniqueidentifier',N'Mainte nance
Plans','00000000-0000-0000 -0000-0000 00000000'
Add the folder if missing:
exec sp_dts_addfolder '00000000-0000-0000-0000-0 0000000000 0','Mainte nance
Plans','08AA12D5-8F98-4DAB -A4FC-980B 150A5DC8'
found this on google.
I found a solution
use msdb
Verify that the folder is missing:
exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfo
nvarchar(17),@P2 uniqueidentifier',N'Mainte
Plans','00000000-0000-0000
Add the folder if missing:
exec sp_dts_addfolder '00000000-0000-0000-0000-0
Plans','08AA12D5-8F98-4DAB
ASKER
I'll check that out after I finish the re-install of SP3. I didn't build the server or do the original SQL install, I'm wondering if maybe the SSIS was installed AFTER sp3 was applied...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi all,
I had to reinstall SQL nothing else worked. Thanks for the help. I'm giving the points to Humprty as he spent a lot of time helping.
I had to reinstall SQL nothing else worked. Thanks for the help. I'm giving the points to Humprty as he spent a lot of time helping.
If you do, do you see SQL Server Logs, DTC, and Legacy, and it's only the Maintenance Plans folder that's missing ?