Restoring only one table in database backup
Posted on 2009-05-04
An issue has come up some missing data in a table in one of my MS SQL 2005 databases. There are a few dozen tables, all actively being used and updated regularly.
What I need to do is to recover ONLY THIS TABLE to look at this data for evaluation. I have seen lots of directions about restoring databases, but haven't seen how to only recover only one table. It would make sense to not overwrite the existing data that has accrued over the last few weeks, but it's not a big deal because I've made copies of this table.
If this doesn't work, how hard is it to create a new database on a different server and restore my backup there to see what it looks like? From there I suppose I could insert any missing data into the live table. Thanks for any input.