How do I archive and restore selected tables using SQL Server? How do I archive and restore selected tables using SQL Server?
You have to use a 3rd party tool such as Red Gate SQL backup pro to restore. Or restore as a different DB and copy across.

Selective restore makes sense, occasionally, but selective backup usually wouldn't. You-d have to roll your own selective backup with SMO for example