SQL Interview: 31 Create a copy of an Azure SQL Database on the same logical server

This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around SQL Server and Azure SQL Database.

Section: Administration Level: Intro

Question:

You have an Azure SQL Database.

How can you create a copy of the Azure SQL Database on the same logical server?

Answer:

The easiest option is to use the CREATE DATABASE AS COPY OF command.

A more roundabout way would be to export the database to Azure storage as a BACPAC file, and then use the Import a Database option in the Azure portal to create the new database.

2025-03-25