Azure SQL Database
An Azure relational database service.
The URL for the database is bicking.database.windows.net. The Resource Group is BickingCPA. Please contact me with any questions.
Restore a full Local DB Backup to a new Azure SQL Server Instance?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 18%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
John Pike
1
Reputation point
I made a full DB backup of a local SQL Server DB. I have that file stored locally on my desktop. I thought that I could just restore the local full backup to my new Azure SQL Server Instance. When I connect to my Azure SQL Server Instance, it does not give me the option to restore a backup via SSMS when I right click on Databases. I no longer have access to the old SQL Server. I thought that having the full DB backup that I would be set. I need help to restore this backup file.
Azure SQL Database
{count} votes
-
GeethaThatipatri-MSFT 29,592 Reputation points Microsoft Employee Moderator2023-01-10T13:53:20.56+00:00 @John Pike Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Regards Geetha
Sign in to comment
2 answers
Sort by: Most helpful
-
-
Alberto Morillo 35,411 Reputation points MVP Volunteer Moderator2023-01-03T23:05:34.267+00:00 You just need to upload the backup file to an Azure Blob Storage and restore the backup from there. Read this documentation for more details.