Restore a SQL Server database to an offline copy
Install SQL Server, if it isn't already there.
Get the backup file onto you local box.
Open SSMS and connect to your local instance
Right-click the "Databases" folder and pick "Restore Database..."
Follow the wizard until you're done