MSSQLSERVER Event ID 3041.
Applies to: Microsoft SQL Server 2005.
Error Message.
Two entries were found in the Event Viewer Application Log. The first one is an
error message, the other one is a warning message. Below you will find both of them.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (6)
Event ID: 3041
Date: 3/12/2008
Time: 5:12:47 PM
User: DOMAIN\USERNAME
Computer: SRVSQL2K5
Description:
BACKUP failed to complete the command BACKUP DATABASE <DB Name>. Check the
backup application log for detailed messages.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e1 0b 00 00 .
0008: 0b 00 00 00 .
0010: 41 00 4e 00 .
0018: 2d 00 53 00 .
0020: 00 00 07 00 .
0028: 61 00 73 00 .
0030: 72 00 00 00
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 3/12/2008
Time: 5:12:47 PM
User: N/A
Computer: SRVSQL2K5
Description:
SQL Server Scheduled Job 'Backup - <DB Name> DB - Full'
(0x5DACB076F39629419A4BDE3544408BDC) - Status: Failed - Invoked on: 2008-03-12
17:12:47 - Message: The job failed. The Job was invoked by User DOMAIN\USERNAME.
The last step to run was step 1 (1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Problem Description.
The two entries that were found in the Event Viewer Application Log were created
when a backup job failed because the target database no longer exists. The
target database was deleted.
![[Company Logo Image]](images/SQLCofee.jpg)
