CODEWITHSUNDEEP
azure-sql-database
amin
amin

Reputation: 123

Statement 'backup log' is not supported in this version of SQL Server

I want to use ASP.NET migrator to connect a backend (the backend used to work with local database, but now, there is no local database)to an Azure database, but I encounter this error!

enter image description here

How can I solve the error?

Thanks

Upvotes: 0

Views: 186

Answers (1)

Sairam Tadepalli
Sairam Tadepalli

Reputation: 1683

According to the screenshot posted, you didn't mention your SQL server version. Let me assume that you are trying to use SQL server 2017 version. In that specific version, some of the feature are deprecated and one of those is BACKUP LOG.

The other alternative procedure is to migrate to the lower versions of the database. There is an article that confirms that, we cannot perform backup from lower version to higher version and viceversa is possible.

Check with the server version and provide more information regarding the version you are using.

Upvotes: 1

Related Questions