CODEWITHSUNDEEP
sql-servert-sqlazure-sql-database
John John
John John

Reputation: 1

Unable to take a snapshot of a database which contain "-" in its name

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:

enter image description here

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

Any advice ?

Thanks

Upvotes: 0

Views: 142

Answers (1)

Ronen Ariely
Ronen Ariely

Reputation: 2434

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

Upvotes: 1

Related Questions