restore one table from sql express backup 2008

I need to restore only one table from my full backup. How Can I do that ?
Jose BredariolPMPAsked:
Who is Participating?
Aneesh RetnakaranDatabase AdministratorCommented:
Restore the backup as another database, then use an insert statement from that restored copy
Truncate table dbo.tableName
INSERT INTO dbo.tableName
SELECT * from Newcopy.dbo.tableName
Use third party tools virtual restore from red-gate if you don’t have sufficient space to restore, the trial version will can be used for 14 days
Jose BredariolPMPAuthor Commented:
OK, thanks for your answer.
I did this :

FROM DISK='d:\Business_Data.bak'


MOVE 'Business_Data'  TO 'D:\TSQL\Business_Data.mdf',

MOVE 'Business_Data_log' TO 'D:\TSQL\Business_Data_log.ldf'
Jose BredariolPMPAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for jbredariol's comment #a38364661

for the following reason:

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Aneesh RetnakaranDatabase AdministratorCommented:
Didnt my comment help ?
Anthony PerkinsCommented:
Please also leave your recommendations for your desired disposition of this question below my comment.
Award point here http:#a38364564
Jose BredariolPMPAuthor Commented:
Yes, It helps a lot.

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.