How to upload .bak file in MSSQL Management Studio?

[anela]

I have a .bak file and I need to upload this database. And I don't know how to upload it.

 

[serverpoint_tom]

Hello Anela,

A. Open SQL Server Management Studio in Object Explorer Right Click on ‘Databases’ Node and select ‘Restore Database’

B. ’Restore Database’ Dialog will be displayed on the General page
1. 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.

2. Select ‘From device’

3. Click button to display ‘Specify Backup’ Dialog

4. Click ‘Add’ to browse the .bak file from the directory and click OK

Thank you,