Restoring just a table from a full backup

is there a way to restore certain tables from a full backup?

Simple answer: No

Although there might be a way if you used a seperate file group for that table.

|||I am not sure. We are using Great Plains 9 and my bose told me he just wants to backup and restore payroll.|||

try some 3rd party tools.

|||You can restore the backup with other name, then copy the desired table from one database to the other.|||great idea|||I believe that is what I will do. thanks.|||

When you use for example SQL LiteSpeed for dumping (also usefull for quick and compressed dumping) there is an option in the admin tool for SQL LiteSpeed where you can restore a single object (view, sp, table, function etc) from a dump.

I have very good experience with SQL LiteSpeed.