IntercareSupport
asked on
Restoring only one table in database backup
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
yes you cannot restore single table from backup file.
For data comparison, Though you can write queries to compare data between databases on different servers but to make things easier, Instead of restoring the database on different server, you can restore it on the same server with different database name. Then if you want to compare the data between tables, you can write some query for this.
To make your query more simpler, you can use DTS (Data Transformation Services) / Sql Queries to copy the table into same database.
For data comparison, Though you can write queries to compare data between databases on different servers but to make things easier, Instead of restoring the database on different server, you can restore it on the same server with different database name. Then if you want to compare the data between tables, you can write some query for this.
To make your query more simpler, you can use DTS (Data Transformation Services) / Sql Queries to copy the table into same database.
ASKER
Thanks, good advice.
ASKER