Share via

Sql backup command issued from custom application results in 3041 error

Darryl Hoar 181 Reputation points
2023-04-21T21:01:03.6233333+00:00

Sql Server 2014 Express edition. Windows 10. Created a custom .NET application which issues a command to the database to backup data. Works like a charm. Database is backed up when the user presses the backup button in the application. This has worked for a long time without issue. Recently (2 days ago), it has failed to backup. Looking in the logs (using SSMS), I see the following message: "Backup Failed to complete the command Backup Database MyDatabaseName. Check the backup application log for detail message". Followed with: Error 3041 Severity: 16 State: 1 Tried to find the backup application log with no success. In the SQL logs I do not see further details regarding this error. What I have done so far:

  1. Use Sql Server Configuration Manager to stop/start SQL Server. Results in no change.
  2. Rebooted computer. Results in no change.
  3. Verified that the drive has plenty of free space (currently only 1/4 full).
  4. Using SSMS - opened a new query. Typed in Backup Database MyDatabaseName To Disk 'C:\temp\junk.bak'. Execute query and result is database is backed up successfully.
  5. Using Windows Event Viewer, looked in the relevant logs and see no details regarding the SQL Error. Using SSMS, I have looked into the SQL Server Logs and see no additional error information proceeding the Error or after the Error. I am stumped. Where can I find this "Backup application log" ? Any ideas the cause ? Nothing has changed on the system as far as I can determine. I am having a difficult time identifying the issue, so any help is greatly appreciated. Unfortunately I cannot upgrade the version of SQL at this time.
SQL Server Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,586 Reputation points
    2023-04-24T06:08:20.9366667+00:00

    Hi @Darryl Hoar,

    Please refer to these related blogs:

    https://mstechtalk.com/how-to-fix-sql-server-error-3041/

    https://bobcares.com/blog/sql-server-backup-error-3041-causes-fixes/

    Hope these would give you some help. Best regards,

    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.