May 10, 2012 at 12:27 am
Hi All
I have backed up MSDB and restored it onto another server
The builds are exactly the same and had no issues restoring
When I create a new Maintenance Plan on the Server that MSDB was restored to, the plan gets created but when I execute it, it fails and goes into a Suspended state
Is there anything I need to do before using MSDB on the Server I restored it to?
Thanks
May 10, 2012 at 1:13 am
can you share the error 🙂
May 10, 2012 at 1:24 am
Pradyothana Shastry (5/10/2012)
can you share the error 🙂
The error says that I need to check the SQLAGENTOUT file
I checked the file and it says:
Step 1 of job 'T.Subplan_1' (0x9F26AEB036BFB049A8788C00BFB028DD) cannot be run because the SSIS subsystem failed to load. The job has been suspended
May 10, 2012 at 1:36 am
Please set the sys subsytem values to proper values.
Example :-
use msdb
go
select * from msdb.dbo.syssubsystems
update syssubsystems set subsystem_dll ='E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\binn\SQLCMDSS.DLL'
where subsystem='CmdExec'
Restart SQL Agent once Done.
Table with values you can find here :- http://support.microsoft.com/?kbid=903205
Map the dll with your DLL files, It must work
May 10, 2012 at 2:44 am
Is that helped?
May 10, 2012 at 2:56 am
Pradyothana Shastry (5/10/2012)
Is that helped?
Yes, Thanks
When I queried the subsystems table, I noticed that it was still referencing the Old system
Thanks
May 10, 2012 at 3:41 am
Welcome 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply