locked
SQL Azure - On premise backup/restore RRS feed

  • Question

  • Hi,

    We have an application running in Azure which relies on SQL Azure. We would like to create on-premise backups of the database once every day and be able to restore them later on. We have been using a tool from RedGate, but unfortunately we've had some quality issues with it and it has been discontinued.

    I'm aware of the CREATE DATABASE AS COPY OF command, but we want an on-premise backup. I also know that there are services online which allows us to backup SQL Azure datbases, but we want a tool which can be run on-premise which will create a full backup of a database and allow us to restore it later on.

    What options are available?

    Regards

    Martin



    • Edited by M. Knafve Tuesday, April 17, 2012 8:46 AM
    Tuesday, April 17, 2012 8:46 AM

Answers

All replies

  • Hi,

    I think you can use SQL Azure DataSync feature for synching databases in SQL azure and on premise SQL Server. For details, check out the link: http://msdn.microsoft.com/en-us/library/windowsazure/hh456371.aspx 

    I hope it helps!!


    If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Thanks! Vaibhav Gujral.

    Tuesday, April 17, 2012 9:27 AM
  • That won't work. We want to perform backup and restore. SQL Azure DataSync is not intended for this (according to the DataSync FAQ). One of the reasons for this is that it does not backup all objects, for instance stored procedures. We've given it a try, and my impression of DataSync is that its intended more for offline processing of data / replication than a clean backup / restore solution.


    Nitramafve

    Tuesday, April 17, 2012 10:50 AM
  • Hi Mitramafve,

    You may have a look at other third party tools to backup both data and schema, such as Enzo Backup for SQL Azure. Please see: Data backup strategies for Windows and SQL Azure.

    Stephanie Lv

    TechNet Community Support

    • Proposed as answer by Paras Doshi Thursday, April 19, 2012 4:51 AM
    • Marked as answer by Challen Fu Monday, May 7, 2012 9:08 AM
    Wednesday, April 18, 2012 1:16 AM
  • How about DACPAC http://dacguy.wordpress.com/

    http://sqldacexamples.codeplex.com/releases/view/71569

    It helps in exporting and importing sQL Database between onpremise and cloud both ways.


    -Sachin Sancheti

    Thursday, April 19, 2012 11:38 AM
  • The Windows Azure SQL Database Backup and Restore article explains the latest options available to create backups and  links to how to articles.

    Thanks,

    Karthika


    Karthika [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, September 20, 2012 4:19 PM