Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Rollback a delete statement.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Rollback a delete statement.." Watch "Rollback a delete statement.." New topic
Author

Rollback a delete statement..

Brian Percival
Ranch Hand

Joined: Jun 23, 2004
Posts: 163
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

Joined: May 26, 2003
Posts: 30764
    
156

Brian,
Only if you have a disk backup.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Brian Percival
Ranch Hand

Joined: Jun 23, 2004
Posts: 163
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

Joined: Feb 07, 2004
Posts: 472

Try net search, some companies can restore any deleted data from your disk, unless you used your disk too long after


Retire your iPod and start with HD Android music player Kamerton | Minimal J2EE container is here | Light weight full J2EE stack | and build tool | Co-author of "Windows programming in Turbo Pascal"
Roseanne Zhang
Ranch Hand

Joined: Nov 14, 2000
Posts: 1953
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

Joined: Jun 23, 2004
Posts: 163
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
 
subject: Rollback a delete statement..