Azure SQL Database

Question

Post reply

Azure SQL Database

free_mascot

One Orange Chip

Points: 27169
More actions
January 13, 2014 at 9:56 pm

#396106

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."
January 14, 2014 at 4:58 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Nice and easy QotD, thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

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."

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 4

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

Andrew Watson-478275 SSCarpal Tunnel Points: 4652 More actions · Answer 5

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

Veteran Jones SSC Eights! Points: 937 More actions · Answer 6

Don't think this question is all that great. There is a backup and restore strategy with Azure.

http://social.technet.microsoft.com/wiki/contents/articles/1792.windows-azure-sql-database-backup-and-restore-strategy.aspx

Thumbs down on this QOTD.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 7

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!

chgn01 SSCarpal Tunnel Points: 4353 More actions · Answer 8

Different ways to Backup your Windows Azure SQL Database

:hehe:

--------------------------------------
;-)“Everything has beauty, but not everyone sees it.” ― Confucius

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 9

JourneyMan Jones (1/14/2014)
Don't think this question is all that great. There is a backup and restore strategy with Azure.
http://social.technet.microsoft.com/wiki/contents/articles/1792.windows-azure-sql-database-backup-and-restore-strategy.aspx
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.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 10

JourneyMan Jones (1/14/2014)
Don't think this question is all that great. There is a backup and restore strategy with Azure.
http://social.technet.microsoft.com/wiki/contents/articles/1792.windows-azure-sql-database-backup-and-restore-strategy.aspx
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

Thomas Abraham SSChampion Points: 10761 More actions · Answer 11

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

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 12

Fair enough. I've edited it to say T-SQL Backup command.

I'll award back points since this one was iffy.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 13

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