SQL Azure Database Backup & Restore

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Cloud Computing » SQL Azure - Administration » SQL Azure Database Backup & Restore

SQL Azure Database Backup & Restore

Rate Topic

Display Mode

Topic Options

Author

Message

SQL*

Posted Wednesday, June 13, 2012 2:21 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 12:54 AM
Points: 414, Visits: 1,455

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?

Thanks

Smile

Post #1314920

Grant Fritchey

Posted Wednesday, June 13, 2012 6:14 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 10:37 AM
Points: 13,375, Visits: 25,158

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1315049

« Prev Topic | Next Topic »

Permissions