SQL Azure Database Backups

While Microsoft has always ensured that your SQL Azure database is replicated multiple times for reliability, there is now a way to perform your own ad-hoc backup.  This is known as copying.  You can copy to the same server or to a different one.  The process is asynchronous.  Full details including the T-SQL syntax (CREATE DATABASE…AS COPY OF) can be found here.

-Krip

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: