title: Azure SQL Backup and Restore
body: <p>I know Azure does automatic backup and restoring based off those automatic backups. I need to create a manual backup of a database. From reading online, I created a bacpac file using Export and saved to an Azure Blob (<a href="http://suxstellino.wordpress.com/2013/02/12/backup-windows-azure-sql-database-with-sql-server-management-studio/" rel="nofollow">how to here</a>). The problem is when I go to 'Restore' using the Azure Portal, it only gives me the option to choose one of their automated backups.</p>
  
  <p>On top of this, I would actually like to restore that database to another database (think restoring Production to Test). I cannot do this either.</p>
  
  <p>I believe they used to have an Import + Export function when in the portal. Now it is Restore and Export, I'm wondering if they somehow took this capability away, I'm not sure.</p>
  
  <p>I know I can create a new database from a .bacpac file, but this does not help me in any way shape or form.</p>