Azure SQL Database
-
Comments posted to this topic are about the item Azure SQL Database
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't." -
Nice and easy QotD, thanks.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
Easy question, but the way it is formulated it seems backups are entirely not possible (the MSDN page gives the same expression) and that your data is not safe. Azure databases are replicated to different servers to deal with disaster recovery. It doesn't protect you from accidental data loss though (for example issuing DROP TABLE by accident).
There are alternatives:
Different ways to Backup your Windows Azure SQL Database
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Hello Koen,
Thank you for sharing additional information.
Best regards,
FM
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't." -
Nice question.
There are more than 20 features that are not supported.
I like SQL Azure.
Thanks,
IgorMi
Igor Micev,My blog: www.igormicev.com
-
It really depends on how broadly you define "backup". Yes, normal SQL backups aren't supported, but you can backup your database, to give some protection against the data loss/corruption mentioned by Koen. See http://msdn.microsoft.com/en-us/library/windowsazure/jj650016.aspx
-
Don't think this question is all that great. There is a backup and restore strategy with Azure.
Thumbs down on this QOTD.
-
Stewart "Arturius" Campbell (1/14/2014)
Interesting question, thanks.Had to read up on this, as I am not too familiar with SQL Azure.
+1. I've tinkered with it, but nothing serious. Good question though; got me to do some research and learn something today.
Everything is awesome! -
Different ways to Backup your Windows Azure SQL Database
:hehe:
--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius -
JourneyMan Jones (1/14/2014)
Don't think this question is all that great. There is a backup and restore strategy with Azure.Thumbs down on this QOTD.
There's a strategy, but it isn't backup and restore as we know it with SQL Server. You cannot run a BACKUP DATABASE command or a BACKUP LOG command.
Whether you see that as a hole or now is up to you, but it isn't the existing method of backing up a transactional database.
-
JourneyMan Jones (1/14/2014)
Don't think this question is all that great. There is a backup and restore strategy with Azure.Thumbs down on this QOTD.
Big +1. I found many refs for Azure backup, such as:
http://msdn.microsoft.com/en-us/library/windowsazure/jj650016.aspx
What am I not getting here?
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn -
Steve Jones - SSC Editor (1/14/2014)
There's a strategy, but it isn't backup and restore as we know it with SQL Server. You cannot run a BACKUP DATABASE command or a BACKUP LOG command.
Whether you see that as a hole or now is up to you, but it isn't the existing method of backing up a transactional database.
The question didn't say that we couldn't run BACKUP DATABASE. It said we attempted to "take a backup". If the OP was referring to something as specific as running a BACKUP DATABASE command, then they should have specified same.
Yes, I learned something, and I appreciate that. But, when questions are sloppily written, don't like not getting them right because I couldn't correctly guess what the poster was attempting to say.
[Edited to correct 'a' to 'are'.]
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn -
Fair enough. I've edited it to say T-SQL Backup command.
I'll award back points since this one was iffy.
-
Steve Jones - SSC Editor (1/14/2014)
Fair enough. I've edited it to say T-SQL Backup command.I'll award back points since this one was iffy.
Thank you Steve!
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn -
Koen Verbeeck (1/13/2014)
Easy question, but the way it is formulated it seems backups are entirely not possible (the MSDN page gives the same expression) and that your data is not safe. Azure databases are replicated to different servers to deal with disaster recovery. It doesn't protect you from accidental data loss though (for example issuing DROP TABLE by accident).There are alternatives:
That list of alternatives includes SQL Data Sync. Is that a safe thing to use for backup? MS have published a warning that says "SQL Data Sync should not be used as part of your backup strategy as there are several limitations. It does not version, it only backs up data and no other objects" - is that now out of date?
Tom
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply