Link to home
Start Free TrialLog in
Avatar of Jose Bredariol
Jose BredariolFlag for Brazil

asked on

restore one table from sql express backup 2008

I need to restore only one table from my full backup. How Can I do that ?
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jose Bredariol

ASKER

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'
I've requested that this question be closed as follows:

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

for the following reason:

Thanks
Didnt my comment help ?
Please also leave your recommendations for your desired disposition of this question below my comment.
Award point here http:#a38364564
Yes, It helps a lot.

Thanks