I have a SQL Server database named db-pwapp-lostandfound-dev, and I want to take a snapshot of it, but I am getting this error - seems like SQL Server does not like - in the name:

I tried to surround the name by [], but I still have the same issue:

Any advice ?

Thanks

CodePudding user response：

The issue is that you are using Azure SQL Database, and it does not support CREATE DATABASE AS SNAPSHOT.