How to know the physical location of a databse in SQL?

Go to SQL Server Management Studio and open a new query pane.

Copy and paste the following querry to verify the physical path of 'mydb'

Replace 'mydb' with your database.

SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('mydb')

Cick Execute.

In the physical_name column, you should see the path to the new location