Forum Discussion
sreenivaskallem
Sep 08, 2023Copper Contributor
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
Sep 08, 2023MCT
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 :
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