• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 770
  • Last Modified:

restore one table from sql express backup 2008

I need to restore only one table from my full backup. How Can I do that ?
0
Jose Bredariol
Asked:
Jose Bredariol
  • 3
  • 2
1 Solution
 
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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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