How do I … backup by using Create Database … As Copy Of to an Azure database (to Azure)
27-Jun-1212 1 Comment
–Start logged into Azure and with master as current database
–Does work 27/06/2012
DROP DATABASE _20120627
CREATE DATABASE _20120627 AS COPY OF
–Must wait for state to be changed from Copying to ?Ready?
SELECT * FROM sys.dm_database_copies
SELECT * FROM sys.databases
SELECT name, state, state_desc from sys.databases where name = ‘_20120627’
–Test that data is there
SELECT * FROM .
Pingback: How do I backup SQL Azure to a Blob Storage Account using bacpac « Steve Shakespeare