Home Forums SQL Server 2005 Backups Backup failure RE: Backup failure

  • April 3, 2014 at 8:18 am

    #1702876

    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