The moose likes JDBC and the fly likes Rollback a delete statement.. Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal
JavaRanch » Java Forums » Databases » JDBC
Reply 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
posted private message
0
Quote
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 26496
    
  78

I like...
Eclipse IDE Java VI Editor
posted private message
0
Quote
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
posted private message
0
Quote
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: 471
posted private message
0
Quote
Try net search, some companies can restore any deleted data from your disk, unless you used your disk too long after

Get power of your iPod with MediaChest | Minimal J2EE container is here | Light weight full J2EE stack | My blog | Co-author of "Windows programming in Turbo Pascal"
Roseanne Zhang
Ranch Hand

Joined: Nov 14, 2000
Posts: 1953
posted
0
Quote
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
posted private message
0
Quote
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Rollback a delete statement..
 
Similar Threads
Connect to db, simple question !!
Database Circular Reference
DB operations and java.lang.RuntimeException: No columns in table: X
Populating tables from the database
Delete from multiple tables.