Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Azure Database Backup & Restore Expand / Collapse
Posted Wednesday, June 13, 2012 2:21 AM


Group: General Forum Members
Last Login: Thursday, October 1, 2015 6:01 AM
Points: 424, Visits: 1,630
Hi All,

How can we take the backup of database in SQL Azure?
--- i have taken the backup of database by using "AS COPY OF" it has created a database

Now, how can i restore this backup?


Post #1314920
Posted Wednesday, June 13, 2012 6:14 AM



Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 15,876, Visits: 30,162
Microsoft doesn't really support a direct mechanism of backup & restore through Azure. You can do an export/import through the Azure storage. I have a blog post about it here. It's not the same thing as a backup.

You could look at Red Gate's Cloud Services utility. It does a lot of what you'd want in a real backup process plus more.

Disclaimer, I work for Red Gate.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1315049
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse