Copy Your Database on Same Server (Windows Azure SQL Database)

to copy your database to a new database on the same server

CREATE DATABASE Database1B AS COPY OF Database1A;