oracle expdp similar method to export datas for SQL Server
There is no way to restore a partial database from a SQL Server backup file.  If you are looking to export and import data from various tables in one SQL Server database to another, you'll need to use one of the following methods:


BCP export and import
SQL Server Integration Services (SSIS)
SQL Server Replication
A third party tool, such as Informatica.  This is not an endorsement of their product.


This question and potentially others listed in the "Related" section to the left may offer more help.