Restore a backup in Microsoft SQL Server 2008 from a bak file

In Start, Programs, Microsoft SQL Server 2008, open SQL Server Management Studio.

In the Object Explorer tree, right click on Databases.

Right click on Restore Database.

Choose From Device and click the ... button that becomes available.

Choose File as Backup Media, then click Add.

Add the file from the tree.

Click the Restore checkbox.

Choose the correct database from the To Database dropdown.