Dovetail Logo

Create a cloned SQL Server Azure Database

Today, I wanted to create a clone of a SQL Server Azure database. I was looking at various ways of doing this, including exporting and re-importing the database, but thankfully, there is a much easier way.

I ran the following SQL command against the master database on the SQL Azure server:

CREATE DATABASE New_database     AS COPY OF Old_Database

For more details, check out the official documentation and this Idera blog post.