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 |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-08-18 : 02:59:29
|
| hi,on my database i have lost data by issuing delete command on the particular table and iam having the back up file of that database earlier luckily.if i want to restore the values into the table ho can i achieve this from that back up file.iam using sql server 2005 |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-18 : 05:35:58
|
| You cannot restore just one table from a BACKUP. Assuming you have a full database backup, RESTORE the backup to another server/database.Transfer the data for that one table into the original database, using bcp or the import/export wizard. |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-08-18 : 05:38:00
|
| When it comes to recover specific table data, unfortunately, Sql Server still not provide any facility like FLASHBACK in oracle, But you can restore your backup database as new name and recover data by comparing both tables. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-18 : 05:39:03
|
Using your backup you can restore the database under a different name.Then you can access the data in the tables you need.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-18 : 05:39:55
|
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2009-08-18 : 06:25:36
|
| Thank you very much |
|
|
|
|
|
|
how to restore table values from bak up file