Restoring single table from full backup?

[jsteph]

Hi all,
I have a db set for Simple recovery model. The data is semi-critical but reproducible. It's backed up weekly. I want to restore just a single table from this db from the full backup--to either a separate tablename or to a new, temporary database--I need to compare some values. Even though the data is reproducible for my purposes I want to just get the data from the backup, Is this possible? Thanks,
--Jim

 

[ptheriault]

nope. you are going to have to restore the entire bak file to a new database. you can not restore just a single table.

- Paul
- If at first you don't succeed, find out if the loser gets anything.