My backup failed BUT why?


#1

This is the log, can someone help?

4/23/2019 10:00 PM Starting scheduled job “Backup Databases " - “Differential”. Computer “WIN-AGQPPB74TS1”. App v.“12.2.3”
4/23/2019 10:00 PM Connecting to SQL Server: 2017 RTM Enterprise Edition (64-bit). WIN-AGQPPB74TS1
4/23/2019 10:00 PM The backup folder “backup” has “268.229GB” free space. The temporary folder backup” has “268.229GB” free space
4/23/2019 10:00 PM Backing up “WIN-AGQPPB74TS1” SQL Server databases
4/23/2019 10:00 PM Getting maximum file size…
4/23/2019 10:00 PM The maximum file size: “”
4/23/2019 10:00 PM The previous Full backup of “Marketplace” database has failed. Creating Full backup.
4/23/2019 10:00 PM Backing up “Marketplace” database to .bak file. Backup type: “Full”. Checksum: “Enabled”
4/23/2019 10:00 PM Verifying “Marketplace” database backup
4/23/2019 10:00 PM Failed to backup “Marketplace” database with “Full” backup type: Type ‘’ cannot be .
4/23/2019 10:00 PM The previous Full backup of “ForumsData” database has failed. Creating Full backup.
4/23/2019 10:00 PM Backing up “ForumsData” database to .bak file. Backup type: “Full”. Checksum: “Enabled”
4/23/2019 10:00 PM Verifying “ForumsData” database backup
4/23/2019 10:00 PM Failed to backup “ForumsData” database with “Full” backup type: Type ‘’ cannot be .
4/23/2019 10:00 PM The previous Full backup of “PWeb” database has failed. Creating Full backup.
4/23/2019 10:00 PM Backing up “PWeb” database to .bak file. Backup type: “Full”. Checksum: “Enabled”
4/23/2019 10:00 PM Verifying “PWeb” database backup
4/23/2019 10:00 PM Failed to backup “PWeb” database with “Full” backup type: Type ‘’ cannot be .
4/23/2019 10:00 PM Cleaning up backups of "Backup Databases " job
4/23/2019 10:00 PM Job "Backup Databases " finished with “3” errors
4/23/2019 10:00 PM Sending job log to error@macierpce.net


#2

Hi MichaelT,

To investigate this case we need more details. Could you please enable the advanced log, reproduce the issue and after the issue will be reproduced please send the log to our dev team. Here are more details on how to do it https://sqlbackupandftp.com/blog/how-to-send-log-to-developers

Please let us know when the log will be sent, also please provide us with your Application ID (“Help” > “About”).

Sorry for the inconvenience.


#3

@Alexander
I sent the log to Developer team already. and here is my application ID: 351392f3-9888-4cd3-bc12-32486b615331

Please let me know what you find out.

Thank you


#4

Can you help?

I sent the log to Developer team already. and here is my application ID: 351392f3-9888-4cd3-bc12-32486b615331

Please let me know what you find out.

Thank you


#5

Hi MichaelT,

Thank you for the log, we have checked it and found out that you get the following error message:

Failed to execute “sp_addumpdevice” SQL procedure because of the permission error. Need to be a member of diskadmin server role and have permission to write to disk. User: —> System.Data.SqlClient.SqlException: User does not have permission to perform this action.

That error message happens when the application tries to remove a backup after the compression and means that a databases’ user doesn’t have permissions to delete that temporary file. Could you please check this?

Sorry for the inconvenience.


#6

I found out that my Database user is not a diskadmin SQL server role. After I checked diskadmin from SQL management studio. It works great now.

Thanks


#7

Good news! Thank you for your reply.

Please feel free to contact us on any issues or concerns.