Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
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 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 at 11:37

1 Answer 1

up vote 3 down vote accepted

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.

share|improve this answer
    
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 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 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 at 10:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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