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 |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2009-03-06 : 15:28:52
|
| I am backing up our database every 3 days.Is it possible to retrieve just one table(Tab_Orders) from .bak backup file.We have lost some data due to incorrect front end functionality.Thank you very much for the helpful info. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-06 : 15:37:42
|
| Restore that bak file with diff name and export that table to desired DB. |
 |
|
|
cplusplus
Aged Yak Warrior
567 Posts |
Posted - 2009-03-06 : 15:44:37
|
Is there a restore table command to get just the table from a backup file?Thks.quote:
Originally posted by sodeep
Restore that bak file with diff name and export that table to desired DB.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-06 : 15:46:30
|
| NO |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-03-06 : 15:54:26
|
| For future reference. You could in theory back up a filegroup that had just that table on it if you think this might be an issue going forward.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
How to retrieve just one table from .bak file