Related Articles

You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file extension, and you use them to restore database backups through Microsoft SQL Server. by navigating to the backup utility and loading the BAK file as a restoration medium, you can open the file and restore the database. If you manage your own databases, which may be the case if you handle your company's tech support on your own, this is an easy way to back up and restore Microsoft SQL databases.

1. Click the name of your SQL server in the Object Explorer pane to expose your databases.

2. Select "user databases," then right-click the name of the database you want to restore (Source 1).

3. Hover your mouse pointer over "Tasks" in the drop-down menu, then hover over "Restore," then click "Database".

4. Click the "From Device" radio button, then click the "..." button to open the backup medium window.

5. Select "File" from the drop-down menu, then click the "Add" button. A file explorer window appears. Navigate to the BAK file, select it, and click "Open" to add the file to the backup medium.