Backup job failing after working for a long time

meklembl

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.

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.

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