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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-28 : 08:00:43
|
| dhiraj writes "I ran a delete statement, and deleted all rows.Can I restore all these deleted records?" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-28 : 08:08:38
|
| If you use Commit Trans then you need to Roll back itOtherwise you need to restore the backupAlways test the delete statements at the Test Database and if you are statisfied with the results then you can apply it to Production DatabaseMadhivananFailing to plan is Planning to fail |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-09-28 : 11:41:58
|
| Hope you have transaction log backup!1. Restore the last full backup.2. Restore point in time, transaction log. (restore till, just before DELETE statment)------------------------I think, therefore I am - Rene Descartes |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-28 : 15:58:53
|
Hi dhiraj, Welcome to SQL Team!You could restore your backup, as ravilobo described, but to a NEW, TEMPORARY database, and then copy the offending table from there to your "live" database - so you won't have to overwrite any other tables in the "restore". Then DROP the temporary database.Brett, I figure you for doing some fishing  here's some more:#43247 +(701)- [X]( dogbert ) how do u do those action thingies?( cams ) alt-f4·· Quits: dogbert (client exited)( cams ) ...( mmmalice ) haha( cams ) are you kidding me?( Psy ) hahahaha* dogbert has joined #pacult( dogbert ) haha funny( Psy ) It's alt f4( Psy ) you hit alt f5·· Quits: dogbert (client exited)Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-29 : 00:57:42
|
| MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
restore all these deleted records?