Import BAK file using SQL Server Management Studio

Importing .bak file using SQL Server Management Studio is basically an act of restoring database from backup. It is very straightforward task. Open Microsoft SQL Server Management Studio

  1. Right click Databases on left pane (Object Explorer).
  2. Click Restore Database…
  3. Choose Device, click ..., and select/add your .bak file
  4. Click OK, then OK again.

Your database backup stored in BAK file will be restored.

Microsoft has covered this topic in detail at this link.

You may also like...