using SQL Server Management Studio
Create new database:
- Databases > Right click > New database
- General > Databasename
- General > Databasefiles > Change path
- OK
Restore backup:
- Select Database > Right click > Tasks > Restore > Database
- General > Device > Browse for .bak
- General > Destination > Select database !
- Options > Overwrite with replace
- OK