We have SQL Azure database running with our website. However today's outage of SQL Azure give us a setback. And now we are looking a way to replicate [as I read on internet] is best to do have 2 database running in some sort of fault tolerance mode. Well, Frankly I didn't know much of terminology or don't have much knowledge. I am software developer and can just manage 100-200MB Database.

Now, my question/request is what we can do to ensure that if one SQL Azure DB is down then we can back our site on other database, which is same, with almost latest data from main database.

I try to search on internet, but most of article use terminology that I hardly understand them. Maybe some wise word will help me find direction. Thanks.

  • 1
    most of article use terminology that I hardly understand them any serious advice here would have to use the same terminology – Remus Rusanu Jan 22 '14 at 11:35
  • I know, but they can at least guide me in direction that a new administrator can use..well maybe :). – Sumit Gupta Jan 22 '14 at 11:37

Traditionally SQL Server relied on technologies like SQL Server Replication, Log Shipping or Change Data Capture/Change Tracking to replicate data across multiple locations. Unfortunately none are available in SQL Azure. Instead SQL Azure has the SQL Data Sync feature:

SQL Data Sync (Preview) is a service of SQL Database that enables you to synchronize the data you select across multiple SQL Server and SQL Database instances. To synchronize your data you create sync groups which define the databases, tables and columns to synchronize as well as the synchronization schedule. Each sync group must have at least one SQL Database instance which serves as the sync group hub in a hub-and-spoke topology.

At this time SQL Data Sync is in preview and has some known limitations.

Also SQL Azure does offer backup/restore and export/import features, see Windows Azure SQL Database Backup and Restore, but these are all 'copy everything' solutions, not 'copy only what is changed'.

A possible solution is to switch to SQL Server on Windows Azure, which gives you a traditional SQL Server instance capable of doing all the technologies above, and you can have it replicate data to a SQL Server hosted on Amazon EC2. See Provisioning a SQL Server Virtual Machine on Windows Azure.

  • Well that make real sense. So, all I can do is SQL Data Sync, as I know I am not enough talented to manage a provisioned server. But do you think provisioning is better option than using SQL Azure. Thanks for answer though. – Sumit Gupta Jan 22 '14 at 16:16
  • 1
    If you don't know how to manage an online server, you will cause outages yourself. Often. With SQL Azure the outages will be provided for you by the service, I mean the outages will become fewer and smaller as the service matures. – Remus Rusanu Jan 22 '14 at 16:55
  • I am using Azure from last 8 months and this is I think second outage, and I love the service already. It is stable then our shared host we use before. But I am researching more on Data Sync if that can help me. You really clear up things by simplying what to look for me :). Thanks – Sumit Gupta Jan 23 '14 at 10:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.