Forum Discussion

Copper Contributor

Sep 08, 2023

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

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 sugg...

NycolasLeduc

MCT

Sep 08, 2023

Hi sreenivaskallem,

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.

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&tabs=ssms#restore-to-sql-server

Consider giving a like at the end of this message if my response could help you resolve your problem.

I hope I was able to help you and wish you a nice end of the day,

Nicolas