Restore Azure SQL from On Premise DB backup (.bak) file

Question

Hi,We have a ".bak" file of a on premise SQL database. It there a way to restore this database in Azure SQL?. We have access to backup(.bak) file only, no access to the direct database. Please suggest best way to deploy this in Azure SQL. Thanks in advance.

nycolasleduc · Answer

Hi&nbsp;sreenivaskallem,&nbsp;Restoring a single file of the backup type is not possible. It will be necessary to restore your database via SQL Server Management Studio on a new Azure server (Classic Compute), this is the best way.&nbsp;Then in SQL Server Management Studio, you will be able to launch the deployment on SQL Database.There is a learn on this subject, it is here :https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&amp;tabs=ssms#restore-to-sql-server&nbsp;Consider giving a like at the end of this message if my response could help you resolve your problem.&nbsp;I hope I was able to help you and wish you a nice end of the day,&nbsp;&nbsp;Nicolas

kidd_ip · Answer

sreenivaskallem&nbsp;&nbsp;Would suggest to follow this as best practice:&nbsp;https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import?view=azuresql&amp;tabs=azure-powershell&nbsp;

Forum Discussion

Restore Azure SQL from On Premise DB backup (.bak) file

2 Replies

Resources