[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1569
  • Last Modified:

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.
0
IntercareSupport
Asked:
IntercareSupport
2 Solutions
 
chapmandewCommented:
you can't recover just that single table w/o restoring the whole db if you havne't planned for it. (filegroups).  SO, restore the backup to a new database, and then just move that table data over to your existing db.  
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
unless the table is on a dedicated tablespace, you have to restore the entire database (under another name, no problem to be done even on the same server).
after that, you can copy back the table with or without data just as needed.
0
 
IntercareSupportAuthor Commented:
Thanks, that's what it was looking like to me, too.  Appreciate it.
0
 
usmanrCommented:
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.
0
 
IntercareSupportAuthor Commented:
Thanks, good advice.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now