Microsoft SQL Server/Database manipulation

Creation
To create a database, its files have to be defined:
 * Master Database File (.mdf)
 * Log Database File (.ldf)

Reading
Then to select it, it's either possible to set it at the beginning of the script: or to call all the objects with their full path. Eg:

Restoration
If the database to restore doesn't exist on the destination server, it's necessary to create it empty first. In SSMS, with a right click on Databases, New database.

The process is a right click on the database to restore, and Restore the database, select the .bak.

Otherwise in SQL it gives: