SQL Server Restore a SINGLE table from a backup
You can't restore a single table directly from your backup to a database.
You could restore your complete backup to new database and then copy your table from there to the desired database.
I went with this, simple and easy, and no disruption to the production db or the other tables which were not affected.
Red Gate SQL Backup doesn't recognize compressed backup files anymore. Just a warning for all those who buy this expensive ToolBelt (like we did), thinking that you now have everything in case of need (like we did) and then find yourself with nothing that you can use (like we do currently).
You can also try some of the 3rd party tools that allow you to attach database backups and work with them as with live databases. You can try SQL Virtual Restore from Red Gate or ApexSQL Restore from ApexSQL or SQL Virtual Database from Idera.
All of these are commercial tools but you can find fully functional trials to get the job done. Additional benefit of all of these is that they require very little additional space unlike standard backup restore.
Sorry for the lack of links to all tools but I can't post more than one link due to low reputation :)
for 100GB database Apex is getting lots of time practically restoring it on destination server. i do not got the point yet
There is another method, but a little more complex. If your single table is getting very large, copy it onto a filegroup. Then use File & Filegroups backup to restore the single table.