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 http://www.red-gate.com/products/dba/sql-virtual-restore/ if you don’t have sufficient space to restore, the trial version will can be used for 14 days
0
 
Jose BredariolPMPAuthor Commented:
OK, thanks for your answer.
I did this :
RESTORE DATABASE Business_Data_TSQL

FROM DISK='d:\Business_Data.bak'

WITH

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

MOVE 'Business_Data_log' TO 'D:\TSQL\Business_Data_log.ldf'
0
 
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:

Thanks
0
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 ?
0
 
Anthony PerkinsCommented:
Please also leave your recommendations for your desired disposition of this question below my comment.
Award point here http:#a38364564
0
 
Jose BredariolPMPAuthor Commented:
Yes, It helps a lot.

Thanks
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.