How to restore a Azure SQL DB to a new server
From the target server, select “Create database.” 2. Fill in the configuration values. Then go “Next Networking” or just go to tab “Additional Settings”. 3. Set “Use existing data” to “Backup” and select a backup from your existing database backups.