CODEWITHSUNDEEP
azure
David Cruwys
David Cruwys

Reputation: 6842

How do I restore an Azure database

Azure is Killing Me, I have just accidently cleared out my database (client database), damn it I hate code first migrations.

I have searched through videos and messages for a way to restore my database and the option is not available.

This video says that restore is available on all tiers (at 20 second mark).

http://channel9.msdn.com/Blogs/Windows-Azure/Restore-a-SQL-Database-Using-Point-in-Time-Restore

This message is in my portal

enter image description here

The help says it should be available in the command bar, but it's not there

enter image description here

Looks like I'm totally screwed by SQL Azure, even though there is plent of writing and videos to say that all databases are backed up on all plans, that seems to be crap.

enter image description here

Upvotes: 0

Views: 158

Answers (1)

Bruno Faria
Bruno Faria

Reputation: 5262

SQL Azure backup information are shown in the servers tab not database.

Navigate to SQL Database >> Servers Tab >> Select your server >> Backups Tab.

If you have any backups it will show in this place.

You can also use powershell to get a list of restore points:

PS C:\> Get-AzureSqlRecoverableDatabase -ServerName xxxxxxxxxx

Name      Edition      ServerName      LastAvailableBackupDate
----      -------      ----------      -----------------------
logs      Basic        xxxxxxxxxx      18/05/2015 16:15:14
tracker   Basic        xxxxxxxxxx      17/05/2015 14:31:49
events    Basic        xxxxxxxxxx      17/05/2015 15:02:23

Said that:

  • Restore button should also appear in the dashboard bottom action bar if you have any backups for the selected database.
  • Automatic Backups were and are still not available on retired web or business tiers.

Upvotes: 2

Related Questions