| Author |
Topic |
|
magmo
Aged Yak Warrior
558 Posts |
 Posted - 2009-04-07 : 09:00:03
|
| HiI need to restore a single database table from a backup file (*.bak), is this possible? And if so, how do I do that? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-07 : 09:15:26
|
Restore as different database name, then merge the new table with old table.And vote for madhi's request for restoring single tables on connect.microsoft.com
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2009-04-07 : 09:56:47
|
| Thanks! shame that this feature isn't supported... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2009-04-07 : 13:47:39
|
| I would be happy to vote for this, but I don't see where I can do this.... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-07 : 14:07:56
|
You have to have a Windows Live login.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-07 : 14:08:18
|
And then you clik on one of the stars.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
magmo
Aged Yak Warrior
558 Posts |
Posted - 2009-04-07 : 14:21:33
|
| Ahhh, those stars. I looked for some kind of form to fill in... Anyway, I graded it 5 stars |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-08 : 03:17:17
|
quote:
Originally posted by magmo
Ahhh, those stars. I looked for some kind of form to fill in... Anyway, I graded it 5 stars
Thanks  Thanks Peso MadhivananFailing to plan is Planning to fail |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-08 : 21:51:55
|
| Actually this feature was available in SQL Server 6.5. I think they removed it because of possibility redundant data that can exist after you restore the table. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-09 : 02:16:48
|
Wouldn't that be the decision of DBA to make?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
restore singe table