Failed to backup "" database with "Full" backup

Application issues
1

Hello,

we need to your assist The backup process of SQLBackup has encountered an error. Please refer to the error message provided below for more information.
9/30/2023 12:40:19 PM [Error] Failed to backup “Aayan” database with “Full” backup type: One or more errors occurred. > Invalid column name ‘last_valid_restore_time’.
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 7456 pages for database ‘Aayan’, file ‘TargetV2’ on file 1.
Processed 1 pages for database ‘Aayan’, file ‘TargetV2_log’ on file 1.
BACKUP DATABASE successfully processed 7457 pages in 0.825 seconds (70.607 MB/sec).

2

Hello logix_erp,

We have checked the error message you sent and noticed that you are receiving the following error:

"Invalid column name ‘last_valid_restore_time’."

It appears that there might be an issue with the column name. Could you please contact your DBA for more details? Please note that this error message is generated by SQL Server, and unfortunately, there is no way for us to resolve it from our end.

If you have any other questions, please feel free to ask.

Thank you, and we apologize for any inconvenience.

3

Hello,
I am capable of performing database restoration and backup tasks using SQL Server Management. However, when using SQLBackupAndFTP, I encounter an issue.

4

Hello logix_erp,

To resolve the issue, we require more details. Could you please provide us with the Advanced Log? You can find instructions on how to send the log to developers at this link: How to send Log to developers | SQLBackupAndFTP’s blog . Once you have sent the log, please notify us and provide us with your App ID (“Help” > “About”).

If you have any other questions, please do not hesitate to let us know.

Thank you, and we apologize for any inconvenience.