November 16th, 2003, 02:42 AM
I executing a batch query to do a delete going on a table which contains over 16 million rows. The delete has been running for more than 24hours and is not finished. If I stop the delete now will it roll everything back? Or will the rows deleted remain deleted?
November 16th, 2003, 04:39 AM
I don't know if you'll get your data back, but it's possible, it should keep a transaction log.
If you just wanted to empty that table you should have used Truncate or a drop -> create, way much faster.
See the docs:
Last edited by pabloj; November 16th, 2003 at 04:41 AM.