How can we help you today? How can we help you today?

Backup job failing after working for a long time

Date 2/25/2011 10:57:26 AM
Log Job History (SQL Backup full job created 10/6/2009 12:39:15 PM)

Step ID 1
Server TFS-2008
Job Name SQL Backup full job created 10/6/2009 12:39:15 PM
Step Name execute master..sqlbackup
Duration 00:00:01
Sql Severity 16
Sql Message ID 50000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: INTELLINET\SQLAdmin. SQL Backup failed with exit code: 586 SQL error code: 18486 [SQLSTATE 42000] (Error 50000). The step failed.
meklembl
0

Comments

2 comments

Sort by
  • Brian Donahue
    SQL Error 18486 is some type of logon failure. Please check your SQL Server's ERRORLOG around the same time for more detailed information.
    Brian Donahue
    0
  • meklembl
    Sure enough. One of the logins got "disabled". Enabled it through SSMS and all is right with the world. Now, I have to find out why that occurred.

    Thanks,
    Larry
    meklembl
    0

Add comment

Please sign in to leave a comment.