Provide backup/restore for SQL Database
Not having a simple backup/restore for SQL Database is a key limiter. Import/export and create DB as copy of aren't sufficient for many application scenarios.
We would like to take a snapshot of our SQL Databases daily. Now we can do this by clicking the Export button on the Management Portal manually. You could help us automate this process.
Backup and resore would take parameters of blob storage location and parameters, would allow / notation. That way the SQL could be backed up and if desired the BAK files could be downloaded for off cloud storage.
This is what i propose:
1) a single click 'backup' solution for a SQL Azure Database.
As soon as you click the button, you are prompted to store the database backup file ( in various format ) and after selecting the format you download the backup file directly to your computer! it will make life a lot easier.
Also, a backup log is maintained on the lightweight DBmanager!
2) Also, a single click 'restore' solution for a SQL Azure database!
We are working on user controlled restore that exposes the system backups that SQL database uses today. I don’t have anything to announce today, but please stay tuned.
David Lean commented
Great to hear. I look forward to what you produce.
I trust it may come with a very different pricing model for backups. Currently paying for an entire day just to make the copy required to take a backup, doubles the cost of your offering.
At most you should only charge for the minutes we use while the backup process is in flight.
Maybe split off one of the DB's make a BLOB copy & resync it. Similar to a RAID copy.
Maybe offer something like Data Protection Mgr to just store the Delta blocks.
Clearly best if there is a way to get Transaction Log Backups working.
I've been using Redgate's cloud backup. It's prefect for regular backups.
For SQL Server backups, I use their data-compare tool. It's awesome. You just schedule it to run each night and it keeps a full copy of the system, live, on a backup server.
Redgate. Just awesome. total lifesaver. Even if they finally get backups working, I'm not changing that process.
Mark Richards commented
you can do this now, with the Export feature from the portal, and I assume there is an API to do it from code. you can even schedule automatic backups. but, beware of the costs of doing this. They actually create a duplicate database before they do the backup. You get charged for that DB. If you backup daily, it basically doubles your DB cost....
The new export features doesn't support federations. So still no decent way of backing these databases up. This simply isn't fit for purpose and we are moving away from SQL Azure.
Joerg Mehlhorn commented
which new copy function do you refer to?
Shannon Lowder commented
This is available now with the database copy feature in WASD.
Shannon Lowder commented
The new database copies covers this, right? If so, this one moves to complete!
James Bolt commented
Not sure how the "Premium Offer for Windows Azure SQL Database” can be seriously considered until we have a strong inbuilt backup including federation support. When will this be available?
Paul Bibby commented
So still no official word ? This was flagged as planned over a year and a half ago and demonstrated in the above link. Can we at least have some official statement on where this is headed ??
David Lean commented
SQL Azure having 3 copies for high availability is a great selling point over Amazon's SQL in a VM.
However it is let down by the SQL Azure backup story, which is totally lame. Even SQL Server v1.1 had a better backup story. The current convoluted answer of creating other instances to schedule & make backups, destroys any confidence that this is a robust production ready solution.
Anything you can do to encourage the Azure dev folks to offer a scheduled online transaction logged backup direct into Azure Storage, would greatly improve the appeal of SQL Azure for production systemsu
Note: This has been outstanding for way too long, at least we can now deploy SQL in an IAAS image & use SQL Agent with real backups. But that puts you head to head with AWS's SQL RDS offering, which has a very strong & very simple Backup Ops story. James Hamilton, Tom Rizzo, Alyssa Henry & other ex-SQL folks have been hard at work making it work well there too.
Please make it a top priority to fix this soon.
James D. Schwarzmeier commented
I wonder if there are any updates on this? I know there are ways to manually copy and then backup the copy to a BACPAC. As I understand it, that involves both manually scripting this, and more importantly, paying for the database copy. It seems like there should be an automatic way to schedule backups without having to pay for anything other than the storage costs of the BACPAC blob.
Brian U commented
Very cool that this has been added in a manual kind of capacity today. Do we know if there is plans to extend this just a little bit further and have scheduling for the backup exports?
Still no news? This is a critical issue and it does not seem possible that Microsoft is still ignoring it.
Microsoft, do you actually want organisations to use Azure Database (was SQL Azure) or not? If so, then please get this sorted asap!
This is a really bad omission.
Ideally we should be able to schedule backups to run in the cloud to cloud storage on a regular basis, as well as to to off-line locations.
This is very important for situation where the data is altered/deleted accidentally, as well as for peace of mind.
Mary, any updates on when this sort of thing will land? It's been more than a year since you posted that comment and it still isn't in the product.
Daniel Smith commented
Is there any progress with the backup situation yet? This is one of the last few remaining blockers for my company.
As the suggestion states, the solution would ideally not involve scripting the database schema and data, but instead creating a transactionally consistent binary backup of the database. Ideally the backup feature would be implemented as a new admin section on the portal that allows us to schedule the backups, and list the available backups to restore. Hopefully this can be done without having to mess about with blob storage etc.
Jason Steele commented
This is absolutely critical - and if I had any votes left I would use them all to get this feature. I have pushed to get Azure adopted in my Enterprise but now I am having to raise this missing functionality as a high risk.
Coming, when exactly?
This is still a blocker for us. We need the capability to restore a database in case a client makes a mess of their data. We currently have over 100 client databases (nearly all under 1 GB) hosted. The cost of backing these up each night to bacpac or similar is bigger than any other cost, and makes the move to azure a non starter.