How To Restore a bak file in SQL Server

How To Restore a bak file in SQL Server - The Simple Way

Steps that are in video

- Open SQL Server Management Studio – SSMS
- Connect to a Server Name and choose an authentication.
- Go to the Object Explorer and click on the Server name to open the tree structure, navigate to Databases
- Rightclick on Databases with the mouse and select Restore Database ...
- When the Database Restore window appears:
- a. Under Source section, select the Device option.
- b. Click the browse button next to Device to open the window to select a backup.
- c. In the window that appears, click Add.
- d. In the dialog box that appears, select the .BAK file you want to restore and click OK.
- e. Click OK to return to the Database Restore window.
- The .BAK file is listed in the restore window.
- If you want to restore the same database: in the menu on the left you can select the options and select the next option.
- Click the OK button to continue the process.
- The window with the process.
- Click OK when the "Database Restore Complete" message appears.

Or you can read it at my blog in dutch with all the necessary steps