Issue:
Error in Application log:
Event ID: 3041 BACKUP failed to complete the command BACKUP LOG <databasename>. Check the backup application log for detailed messages.
Source: MSSQL$SQLEXPRESS
Cause:
This issue happens when the db-backupoperator does not have backup permission on the problematic database. Follow the below procedure the solve the issue.
Solution:
Error in Application log:
Event ID: 3041 BACKUP failed to complete the command BACKUP LOG <databasename>. Check the backup application log for detailed messages.
Source: MSSQL$SQLEXPRESS
Cause:
This issue happens when the db-backupoperator does not have backup permission on the problematic database. Follow the below procedure the solve the issue.
Solution:
- Login to the server were the above mentioned problematic database is installed.
- Open SQL Server management studio (SSMS) and login as domain Admin.
- Then expand the Security folder > Expand Logins then select and right click NT AUTHORITY/SYSTEM account > click properties.
- On the properties tab select User Mapping > click problematic database and put a check mark > then select 'db-backupoperator' and put a tick mark, click Ok. See the example screenshot below.
- Close the SSMS console.
1 comment:
Dear, I have the same problem, try what it advises in the post but it does not work me sique appearing the error. I give you my error log:
Fecha,Origen,Gravedad,Mensaje
08/04/2017 10:15:29,,Desconocido,BACKUP failed to complete the command BACKUP DATABASE BDTRANSPORTES. Check the backup application log for detailed messages.
08/04/2017 10:15:29,,Desconocido,Error: 3041 gravedad: 16 estado: 1.
08/04/2017 10:15:29,spid53,Desconocido,A time-out occurred while waiting for buffer latch -- type 3 bp 03DBD528 page 1:1152 stat 0x2c00009 database id: 5 allocation unit Id: 384239400910848/102764424200192 task 0x002085C8 : 0 waittime 300 flags 0x22 owning task 0x007E05C8. Not continuing to wait.
Thanks
Post a Comment