Backup failure

Question

Post reply

Backup failure

Sushant Yadav

SSCrazy

Points: 2780
More actions
March 29, 2014 at 3:27 am

#291555

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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 1

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

Sushant Yadav SSCrazy Points: 2780 More actions · Answer 2

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

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 3

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

Sushant Yadav SSCrazy Points: 2780 More actions · Answer 4

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

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 5

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