This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Rollback a delete statement..

 
Brian Percival
Ranch Hand
Posts: 163
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not particularly JDBC related, and I think I know the answer already, but never hurts to ask...

Sql Server 2005, management studio.. "open Table"ed, selected All rows in the table rightclicked and "Delete"d, closed the management studio.

Is there any way to retrieve the deleted records?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Brian,
Only if you have a disk backup.
 
Brian Percival
Ranch Hand
Posts: 163
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I checked that.. we are supposed to have weekly backups, but for some reason (log file in use may be..) there were no backups for the databases.. So no help in that direction..
Thanks for your response..

Brian
 
D Rog
Ranch Hand
Posts: 472
Linux Objective C Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try net search, some companies can restore any deleted data from your disk, unless you used your disk too long after
 
Roseanne Zhang
Ranch Hand
Posts: 1953
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by D Rog:
Try net search, some companies can restore any deleted data from your disk, unless you used your disk too long after


Heard that, it is used on the criminal cases or ...

I guess it would be very costly.
 
Brian Percival
Ranch Hand
Posts: 163
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a lot for all your responses.. NetSearch is 'waaaay out there' for my scenario, nevertheless a valuable piece of info for future. Thanks again.

Brian
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic