Error: DatabaseName field can't has null value

Application issues
1

Hi,

I have SQLBackUpAndFTP running on several web servers, backing up MSSQL Express databases to Amazon S3 Storage. The back-ups work okay — I can see the files in the various S3 buckets.

However, I’ve just tried to restore several of the databases from the various buckets to a local SQL Server Express instance running on my dev machine and all of them fail with the error: “DatabaseName field can’t has null value”.

Could anyone suggest why this is happening please and how I can get restore to work?

Many thanks

2

I’ve enabled advanced logging but am struggling to unpick anything in there (there’s a lot of log data!). Could anyone advise where to start here because at the moment this is a bit of a showstopper. The databases from the back-up can be manually restored in SSMS so it seems that they’re okay — there are too many to do manually though so I really need to try to automate this. Thanks for any pointers.

3

Hello Dan,

To resolve the issue, we need more details. Could you please provide us with the Advanced Log How to send Log to developers | SQLBackupAndFTP’s blog

Once the log will be sent, please notify us and provide with your App ID (“Help” > “About”).

If you have any other questions, please let us know.

Thank you and sorry for the inconvenience.

4

Ah-ha! It looks like it was restoring to a different version of SQL Server. I’ve ensured that both the backed-up SQL Server and restoration SQL Server are the same versions and the restore completes successfully.

5

Hi Dan,

Good news! Thank you for your reply.

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