We were seeing the following on our Windows 2016 server running sQL 2014:
Log Name: Application
Source: MSSQLSERVER
Date: 25/10/2019 00:19:28
Event ID: 3041
Task Category: Backup
Level: Error
Keywords: Classic
User: NT SERVICE\MSSQLSERVER
Computer: server.domain.local
Description:
BACKUP failed to complete the command BACKUP LOG Managed Metadata Service_51cd38bf72394105be73a0d7d1d6e24e. Check the backup application log for detailed messages.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">3041</EventID>
<Level>2</Level>
<Task>6</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2019-10-24T23:19:28.014493800Z" />
<EventRecordID>145120</EventRecordID>
<Channel>Application</Channel>
<Computer>server.domain.local</Computer>
<Security UserID="S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003" />
</System>
<EventData>
<Data>BACKUP LOG Managed Metadata Service_51cd38bf72394105be73a0d7d1d6e24e</Data>
<Binary>E10B0000100000000C000000540043004800410049004B004F00560053004B005900000000000000</Binary>
</EventData>
</Event>
It turned out that there was an old server share entry in our maintenance plan that needed to be removed...
Log Name: Application
Source: MSSQLSERVER
Date: 25/10/2019 00:19:28
Event ID: 3041
Task Category: Backup
Level: Error
Keywords: Classic
User: NT SERVICE\MSSQLSERVER
Computer: server.domain.local
Description:
BACKUP failed to complete the command BACKUP LOG Managed Metadata Service_51cd38bf72394105be73a0d7d1d6e24e. Check the backup application log for detailed messages.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">3041</EventID>
<Level>2</Level>
<Task>6</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2019-10-24T23:19:28.014493800Z" />
<EventRecordID>145120</EventRecordID>
<Channel>Application</Channel>
<Computer>server.domain.local</Computer>
<Security UserID="S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003" />
</System>
<EventData>
<Data>BACKUP LOG Managed Metadata Service_51cd38bf72394105be73a0d7d1d6e24e</Data>
<Binary>E10B0000100000000C000000540043004800410049004B004F00560053004B005900000000000000</Binary>
</EventData>
</Event>
It turned out that there was an old server share entry in our maintenance plan that needed to be removed...
0