I follow Pinal Dave’s blog for a while. It is a blog about SQL Server and it has been giving me
Rolled back is a concept related to transaction. It is to undo everything that has been done so far in the current transaction and close the transaction so that the data is in the exact same state right before the transaction started. When a transaction is already done or closed, that means the changes made in a transaction is already committed, it can not be rolled back any more. A single delete statement itself equals a transaction. Once it’s done, it’s done. It can not be rolled back. The only way to recover the data is to restore your database to a state back in time when the data still exist.
Sorry, the comment form is closed at this time.