Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Backup failure Expand / Collapse
Author
Message
Posted Saturday, March 29, 2014 3:27 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, October 13, 2014 5:54 AM
Points: 580, Visits: 562
Need your help to resolve below error.

Error:- Unable to start execution of step 1 (reason: The SSIS subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.

SQLAGENT.OUT file for details :-

Step 1 of job 'DB Backup.Subplan_1' (0x49D8001CB6197D448105D80FB5F78E04) cannot be run because the SSIS subsystem failed to load. The job has been suspended

When I run job it enters into suspended state, and it doesn't allow me to stop as it is not in running state.
Post #1556198
Posted Monday, March 31, 2014 8:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:59 PM
Points: 1,194, Visits: 2,222
Check the SQLAgent Error Log to see any error messages.

Did you restore the msdb from a different server or moved the Maintenance plan from a different server ?

Run this

SELECT * FROM msdb.dbo.syssubsystems


Check if the SSIS dll is missing in the location shown by the above query.

--
SQLBuddy
Post #1556515
Posted Tuesday, April 1, 2014 3:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, October 13, 2014 5:54 AM
Points: 580, Visits: 562
thanks sqlbuddy for your reply.
but it is showing me following out on execution of select statement
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL
Post #1556858
Posted Tuesday, April 1, 2014 9:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:59 PM
Points: 1,194, Visits: 2,222
Sushant Yadav (4/1/2014)
thanks sqlbuddy for your reply.
but it is showing me following out on execution of select statement
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL


Check if you could find that dll in that location.

--
SQLBuddy
Post #1557062
Posted Wednesday, April 2, 2014 12:46 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, October 13, 2014 5:54 AM
Points: 580, Visits: 562
no that dll is not present on

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL
location

I found that on following location

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLDTSSS90.DLL
Post #1557336
Posted Thursday, April 3, 2014 8:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 7:59 PM
Points: 1,194, Visits: 2,222
Sushant Yadav (4/2/2014)
no that dll is not present on

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\binn\SQLDTSSS90.DLL
location

I found that on following location

C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLDTSSS90.DLL


Backup MSDB database.

Run this and restart SQL Server Agent .. Check if this fixed the issue


use msdb
go
delete from msdb.dbo.syssubsystems
exec msdb.dbo.sp_verify_subsystems 1
go

--
SQLBuddy

Post #1558002
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse