Backup failure

  • 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.

  • 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

  • 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

  • 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

  • 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

  • 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

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

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