Restore only one table from back up file

Experts,
I am using MS SQL SERVER 2005. Is there a way to restore only one table from database back up file?
Any help, would be much appreciated.
Thanks,
andrishelpAsked:
Who is Participating?
 
SharathConnect With a Mentor Data EngineerCommented:
No, You can create a database with only one table and backup-restore that database to another server.
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
you cannot restore a single table from the backup.
you need to restore the backup fully (to another db name), and then you can recover structure and/or data (as needed) from that table to the original db
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.