Backup Azure from PC

Backup Job - 1 backup has failed

Summary (Failed)

Job: Backup Job - 1
Server: DESKTOP-CU9QK3E
Date: 11/6/2021 4:34:28 PM
Backup type: Full
Backup archive size: 0B

MorthoTest Database backup: failed
MOrthoTestNew Database backup: failed
master Database backup: failed

Next backup: 11/7/2021 9:26:00 AM - Full

Detailed Log:

  • 4:34:28 PM : Starting job "Backup Job - 1 " - “Full”. Server “DESKTOP-CU9QK3E”. System account “SYSTEM@WORKGROUP”. App v.“12.6.7”.
  • 4:34:28 PM : Connecting to: 2014 RTM SQL Azure. tcp:morthotest.database.windows.net,1433.
  • 4:34:29 PM : The temporary folder “F:\SQLBackups\temp\Pranas.NET\SBF\93adcc9a-1a50-4ddf-86c9-1c325fddf1c3\backup” has “1.748TB” free space.
  • 4:34:29 PM : Backing up “tcp:morthotest.database.windows.net,1433” SQL Server databases.
  • 4:34:29 PM : Backing up “MorthoTest” with “Full” backup type.
  • 4:34:29 PM : ERROR: Failed to backup “MorthoTest” database with “Full” backup type: One or more errors occurred. > Statement ‘BACKUP DATABASE’ is not supported in this version of SQL Server.
  • 4:34:29 PM : Backing up “MOrthoTestNew” with “Full” backup type.
  • 4:34:29 PM : ERROR: Failed to backup “MOrthoTestNew” database with “Full” backup type: One or more errors occurred. > Statement ‘BACKUP DATABASE’ is not supported in this version of SQL Server.
  • 4:34:29 PM : Backing up “master” with “Full” backup type.
  • 4:34:29 PM : ERROR: Failed to backup “master” database with “Full” backup type: One or more errors occurred. > Statement ‘BACKUP DATABASE’ is not supported in this version of SQL Server.
  • 4:34:29 PM : Cleaning up backups of "Backup Job - 1 " job.
  • 4:34:29 PM : Deleting temporary files.
  • 4:34:29 PM : ERROR: Job "Backup Job - 1 " finished with “3” errors.

Hi michael_murphy,

It seems you use the wrong server type during the connection. Could you please make sure you use Azure SQL Server and try again?

If you have any other issues please let us know.

Thank you and sorry for the inconvenience.

yes, the problem is resolved

Hi michael_murphy,

Good news!

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