Unable to restore database in Azure Data Studio

First beware that Azure Data Studio is being retired 2026-02-28. You should over to VS Code (since you are on a MacBook.)

I see that the database is in simple recovery, so this is not a database in Azure, at least not Azure SQL Database. Thus, you cannot use the portal as Saraswathi suggested.

Then again, you can use T-SQL. It may be as simple as this:

RESTORE DATABASE db FROM DISK = '<pathtobackup>'

But if the backup comes from another server, you may get errors on the file locations. In this case, first to:

RESTORE FILELISTONLY FROM DISK = '<pathtobackup>'

Make note of the names in the first column. For simplicity, assume that the names are db and db_log.

Then you do:

RESTORE DATABASE db FROM DISK = '<pathtobackup>'
WITH MOVE 'db' TO '<newfilepath\db.mdf'>',
MOVE 'db_log' TO '<newfilepath\db.ldf>'

As for the value of newfilepath, run sp_helpdb on any of your existing databases, and use the folder that you find.