a table got screwed up and I need to restore it from a
nightly backup. All I can find to do is restore the
entire database, how do I restore only one file at a time?

In article <01c001c3a4a5$7d3e7470$a501280a (AT) phx (DOT) gbl>, dane
<anonymous (AT) discussions (DOT) microsoft.com> writes
SQL Server does not have one file per table. A DB can have multiple
files but that is a whole different story. You cannot restore an
individual table from a database backup.

Restore the databse to a new name, and then copy the required table or
data back into the live database.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org