Import .bak file to a database in SQL server
database-restore, sql-server
Solution
On SQL Server Management Studio
- Right click Databases on left pane (Object Explorer)
- Click Restore Database...
- Choose Device, click ..., and add your .bak file
- Click OK, then OK again
Done.
Problem
I have a file with `.bak` extension. How can I import this file data to a database in SQL Server?