January 31, 2011 at 3:23 am
I have a Full Database Backup , now if i have to restore only one Table in that Database. Can anyone please let me know how to do it. This is a Repeated question that i have facing and having no answer. Appriciate all the Help.
January 31, 2011 at 3:43 am
Restore the backup file to a newly created database.On this database, go to the table you
want to restore and transfer the contents of that table into the database you want to transfer\restore.
M&M
January 31, 2011 at 5:59 am
Without using a third party tool, your only option is as described above, a full restore to a different location or a different database and then migrate the tool over.
You can get third party tools, such as SQL Virtual Restore[/url] from Red Gate[/url] (my employer) that will enable you to directly restore individual objects or even rows from a backup.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 31, 2011 at 2:12 pm
iamsam.sandeep (1/31/2011)
I have a Full Database Backup , now if i have to restore only one Table in that Database. Can anyone please let me know how to do it. This is a Repeated question that i have facing and having no answer. Appriciate all the Help.
do you want just the schema or schema and data?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2011 at 10:16 pm
Both
February 1, 2011 at 7:14 am
1) restore the entire database under a different name and pull the table out yourself (perhaps using Import Data Wizard).
2) use a third party tool (ApexSQL, Red-Gate, Idera, others?) to extract table from backup.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply