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.
| Author |
Topic |
|
er.puneet
Starting Member
6 Posts |
 Posted - 2009-07-18 : 02:00:20
|
| Hi everyone,I want to restore a single table from SQL SERVER 2005 backup. Is it possible to this.Puneet Sharma |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-18 : 02:06:49
|
no. Not possible.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-18 : 02:07:32
|
| nope. you can only restore the db as a whole. but what you can do is restore db with a new name and copy the table only from restored db to original db. |
|
|
|
er.puneet
Starting Member
6 Posts |
Posted - 2009-07-18 : 02:10:57
|
Thanks for your replies... Puneet Sharma |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-07-18 : 02:18:02
|
i think some of those 3rd party backup software can do this. Check out their web site.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-18 : 02:19:08
|
quote:
Originally posted by er.puneet
Thanks for your replies...Puneet Sharma
welcome |
|
|
|
|
|
|
Restoring a single table from database backup