Backup Differencial error

Forum for users of Redgate's SQL Backup tool

Backup Differencial error

Postby dklein9930 » Thu May 15, 2014 2:32 pm

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,
dklein9930
 
Posts: 13
Joined: Wed Mar 02, 2011 3:27 pm

Postby petey » Fri May 16, 2014 12:14 pm

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.

Code: Select all
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 7
petey
 
Posts: 2301
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests