Geek asks and answers

Is SQL Azure Data Recovery Possible?

I just made a dizzying mistake. I think that I was connected to my local dev db, I accidentally used the following script for my Azure SQL database for production:

DELETE myTable
GO

My data is gone forever, as I'm afraid, or does SQL Azure have a magic button "Roll back to 1 hour ago"?

Is there anything I can do to recover the data from the table?

(BTW, no, I don’t have a database backup. Azure SQL does not support backups. And, yes, I understand that it probably answers my own question ... I just hope I'm wrong.)

+3
source share
2 answers

Refresh

Azure SQL Basic, Standard Premium. Point in Time Restore . Geo-Replicated , (1 RPO V12).

Azure SQL Database : https://msdn.microsoft.com/en-us/library/azure/jj650016.aspx.

Point in Time Restore Geo-Restore Azure SQL.

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

; . , DROP DATABASE, , ( ) , . .

4 SQL Azure . SQL Azure . , , . , . , , , .

Transact SQL :

destination_database_name       AS COPY [__.] Source_database_name Adventure Works , :

CREATE DATABASE [AdvetureWorksBackup] [AdventureWorksLTAZ2008R2] , SQL Azure.

+5

More articles:


All Articles