SQL Server Red-gate database Backup Restore is failing with error(1) in SQL Server agent job,
On running step manually from SSMS we got error (2)
Error1: "SQL Backup failed with exit code: 5145 SQL error code: 0 [SQLSTATE 42000] (Error 50000). "
Error2: "Error: ERRSQB: 5145 (Failed to start SQL Backup Agent service.) (): 5 (Access is denied.)"
As error clearly states that there is issue with SQL backup agent in red-gate , we have open services.msc and check for service. In my server SQL backup agent was in stopped state due to last night server reboot.
I have started the services and job completed successfully.
No comments:
Post a Comment