Restore the database from a BAK file
Right-click on the database server in the left navigation pane, click Tasks, click Restore.
The name of the restoring database appears in the To database list box.
To create a new database, enter its name in the list box. Select 'From device'.