Options

Backup Differencial error

dklein9930dklein9930 Posts: 20
edited May 16, 2014 7:14AM in SQL Backup Previous Versions
Executed as user: ''. SQL Backup failed with exit code: 5160 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.


What error does this indicate?

Thanks,
· Share on Twitter

Comments

  • Options
    peteypetey Posts: 2,358 New member
    The error code indicates that the SQL Backup extended stored procedure could not get access to the SQL Backup server components shared object. This can happen if you changed the SQL Server service's startup account.

    Could you please try restarting the SQL Backup Agent service and see if it resolves the issue? Once restarted, try running a test backup via Management Studio e.g.
    EXEC master..sqlbackup -sql "BACKUP DATABASE model TO [<AUTO>]"'
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.