Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Restore just one table from BAK

Author  Topic 

jooorj
Posting Yak Master

126 Posts

Posted - 2011-07-14 : 01:42:11
Hello,
I need to restore only 1 Table from (aa.bak)
without restoring all database.
is there any way ?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-07-14 : 02:17:20
No.
You can restore the database with a new name and then you have access to the table you want.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-07-14 : 03:21:04
http://www.red-gate.com/products/dba/sql-backup/object-level-recovery


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-07-14 : 06:56:30
If you're adventurous: http://weblogs.sqlteam.com/mladenp/archive/2010/10/12/sql-server-ndash-undelete-a-table-and-restore-a-single.aspx
Go to Top of Page

Devart
Posting Yak Master

102 Posts

Posted - 2011-07-14 : 08:16:08
Hello,

If you need to restore only the data in Table
you can use http://www.devart.com/dbforge/sql/datastudio/datastudiosql.exe .
If table structure also is different you can use
http://www.devart.com/dbforge/sql/schemacompare/schemacomparesql.exe
before it.


Devart,
SQL Server Tools:
dbForge Data Studio
dbForge Schema Compare
dbForge Data Compare
dbForge SQL Complete
Go to Top of Page

jooorj
Posting Yak Master

126 Posts

Posted - 2011-07-14 : 08:44:09
thank you very much
Go to Top of Page
   

- Advertisement -