How to import a bak file into SQL Server Express
stackoverflow.com › questions › 20837673Dec 30, 2013 · Click Start, select All Programs, click Microsoft SQL Server 2008 and select SQL Server Management Studio. This will bring up the Connect to Server dialog box. Ensure that the Server name YourServerName and that Authentication is set to Windows Authentication. Click Connect. On the right, right-click Databases and select Restore Database.
How to open a .bak file – SqlBak Blog
blog.sqlbak.com › open-a-bak-fileFeb 22, 2014 · To restore a .bak file using SQL Server Management Studio ( SSMS) you must do the following steps. On the database you want to restore, right-click it then go to Tasks -> Restore -> Database, as can be seen below. Then check the radio button From device and click on the button to browse for the location of the .bak file.