Share
VIDEOS 1 TO 50
How to Rollback an Update Statement
How to Rollback an Update Statement
Published: 2015/09/30
Channel: Amanda Siegel
Tech Tip - SOLIDWORKS PDM Rollback Command
Tech Tip - SOLIDWORKS PDM Rollback Command
Published: 2016/05/04
Channel: CADimensions, Inc.
Oracle DBA - Rollback Segment
Oracle DBA - Rollback Segment
Published: 2010/06/20
Channel: HandsonERP
Transaction Failure, Recovery and Log
Transaction Failure, Recovery and Log
Published: 2016/03/10
Channel: Techtud
Informatica MDM 10 -  How to Rollback HotFix and Patch or EBF
Informatica MDM 10 - How to Rollback HotFix and Patch or EBF
Published: 2017/08/16
Channel: Sandip M
How To Rollback Undo A WordPress Theme Or Plugin To A Prior Version
How To Rollback Undo A WordPress Theme Or Plugin To A Prior Version
Published: 2017/04/18
Channel: WPCrafter.com WordPress For Non-Techies
ROLLBACK AND UNDO
ROLLBACK AND UNDO
Published: 2009/04/22
Channel: Saif Elyzal
Recoverable and Nonrecoverable Schedules in Transaction
Recoverable and Nonrecoverable Schedules in Transaction
Published: 2016/03/12
Channel: Techtud
SOLIDWORKS Enterprise PDM - Rollback Functionality
SOLIDWORKS Enterprise PDM - Rollback Functionality
Published: 2014/11/03
Channel: GoEngineer
Basic of Transaction | DBMS | part-17
Basic of Transaction | DBMS | part-17
Published: 2016/11/17
Channel: KNOWLEDGE GATE
File History, Rollback and Details - 12d Synergy Training
File History, Rollback and Details - 12d Synergy Training
Published: 2016/02/19
Channel: 12d Synergy
How to disconnect all connections on sql server database |kill all connections |disconnect all users
How to disconnect all connections on sql server database |kill all connections |disconnect all users
Published: 2016/02/26
Channel: Rohan Mehtha
Rollback and Transaction Logs
Rollback and Transaction Logs
Published: 2016/07/21
Channel: Christopher Kalodikis
SQL: TRANSACTION CONTROL STATEMENTS (COMMIT, ROLLBACK, SAVEPOINT)
SQL: TRANSACTION CONTROL STATEMENTS (COMMIT, ROLLBACK, SAVEPOINT)
Published: 2010/05/24
Channel: TechnicalSkills
18. Savepoint, Rollback and Commit in Oracle
18. Savepoint, Rollback and Commit in Oracle
Published: 2014/01/27
Channel: Programming in Hindi
Transactions commit and rollback with Entity Framework in MVC
Transactions commit and rollback with Entity Framework in MVC
Published: 2014/07/06
Channel: Vijay Malviya
RollBack Rx - How to recover data from a snapshot.
RollBack Rx - How to recover data from a snapshot.
Published: 2013/02/22
Channel: Horizon DataSys
Cascading Abort and Cascadeless Schedule
Cascading Abort and Cascadeless Schedule
Published: 2016/03/16
Channel: Techtud
Oracle - Commits, Rollbacks and Transactions
Oracle - Commits, Rollbacks and Transactions
Published: 2011/09/13
Channel: Chris Ostrowski
Transaction Processing - Part 2 -07 - Cascading Rollback and Cascadless schedule
Transaction Processing - Part 2 -07 - Cascading Rollback and Cascadless schedule
Published: 2017/02/22
Channel: محمد الدسوقى
SCPT 44: Undo Management In Oracle
SCPT 44: Undo Management In Oracle
Published: 2011/05/23
Channel: Oresoft LWC
BIMFRAME CONNECT - Part 5 - Rollback data and Download PDF.XLS files
BIMFRAME CONNECT - Part 5 - Rollback data and Download PDF.XLS files
Published: 2013/06/16
Channel: Daniel Monsén
Start Transaction ROLLBACK, COMMIT
Start Transaction ROLLBACK, COMMIT
Published: 2016/04/02
Channel: Kevin E. Ogbonna
DEMO | Oracle Source Volume Rollback
DEMO | Oracle Source Volume Rollback
Published: 2013/06/14
Channel: InMageRecovery
Transactions in Visual Studio - Commit and Rollback
Transactions in Visual Studio - Commit and Rollback
Published: 2017/05/03
Channel: Arshman Saleem
Database Transactions, part 2: Examples
Database Transactions, part 2: Examples
Published: 2013/04/10
Channel: Barry Brown
Java JDBC Tutorial – Part 7: JDBC Transactions with MySQL
Java JDBC Tutorial – Part 7: JDBC Transactions with MySQL
Published: 2014/09/08
Channel: luv2code
AppSense - User Personalization Profile Rollback
AppSense - User Personalization Profile Rollback
Published: 2010/01/21
Channel: AppSense
DBMS: Characteristics of Database Management System[HD]
DBMS: Characteristics of Database Management System[HD]
Published: 2012/10/09
Channel: Dr.Caos Engineering
Database Transactions, COMMIT and ROLLBACK: SQL Tutorial  89
Database Transactions, COMMIT and ROLLBACK: SQL Tutorial 89
Published: 2017/07/19
Channel: Solution Wizard
PHP MySQL Transaction Tutorial
PHP MySQL Transaction Tutorial
Published: 2011/12/04
Channel: JREAM
Declarative Transaction Management with Spring Boot
Declarative Transaction Management with Spring Boot
Published: 2015/03/02
Channel: LeanStacks
Does the transaction rollback on exception in spring transaction management? | javapedia.net
Does the transaction rollback on exception in spring transaction management? | javapedia.net
Published: 2017/01/13
Channel: javapedia.net
JMS Rollback transaction in mule ESB
JMS Rollback transaction in mule ESB
Published: 2016/08/03
Channel: shankar santosh
Transaction SQL Tutorial | SQL Commit and Rollback | ACID Property in SQL | Edureka
Transaction SQL Tutorial | SQL Commit and Rollback | ACID Property in SQL | Edureka
Published: 2015/03/12
Channel: edureka!
MySQL Transactions
MySQL Transactions
Published: 2012/02/27
Channel: Michael Crosby
Sql Server begin tran, commit y rollback
Sql Server begin tran, commit y rollback
Published: 2013/05/21
Channel: CursosdeComputacion .Net
Schema Archiving with DB Change Manager
Schema Archiving with DB Change Manager
Published: 2014/10/18
Channel: Embarcadero Technologies
How To Use SOLIDWORKS PDM Rollback
How To Use SOLIDWORKS PDM Rollback
Published: 2017/02/14
Channel: SOLIDWORKS Support Solutions
SCPT 43: How Commit and Rollback Works in Oracle
SCPT 43: How Commit and Rollback Works in Oracle
Published: 2011/05/23
Channel: Oresoft LWC
DDL, DML, DCL & TCL statements in SQL (Database basics)
DDL, DML, DCL & TCL statements in SQL (Database basics)
Published: 2016/04/15
Channel: SQL with Manoj
ACID Property in Database Management System
ACID Property in Database Management System
Published: 2015/12/24
Channel: Techtud
How to recover deleted data in SQL Server
How to recover deleted data in SQL Server
Published: 2015/01/04
Channel: Muhammad Imran
ACID Properties | DBMS | part-18
ACID Properties | DBMS | part-18
Published: 2016/11/18
Channel: KNOWLEDGE GATE
Commit and Rollback API in Java Transformation
Commit and Rollback API in Java Transformation
Published: 2013/10/25
Channel: InfaMarketplace
SQL SERVER /SSIS/SSRS Training in Online/In-Person
SQL SERVER /SSIS/SSRS Training in Online/In-Person
Published: 2015/11/21
Channel: #OnlineTraining
Use Update with rollback in SQL
Use Update with rollback in SQL
Published: 2016/05/03
Channel: Techie Rajesh
Restoring the BIOS on HP Computers with a Key Press Combination
Restoring the BIOS on HP Computers with a Key Press Combination
Published: 2016/05/27
Channel: HP Computing Support
DATABASE TRANSACTIONS-1 IN HINDI
DATABASE TRANSACTIONS-1 IN HINDI
Published: 2013/11/01
Channel: Ajaze Khan
Restoring database backups Differential and Transaction Log Backups, Part 4
Restoring database backups Differential and Transaction Log Backups, Part 4
Published: 2012/08/24
Channel: techytube
NEXT
GO TO RESULTS [51 .. 100]

WIKIPEDIA ARTICLE

From Wikipedia, the free encyclopedia
Jump to: navigation, search

In database technologies, a rollback is an operation which returns the database to some previous state. Rollbacks are important for database integrity, because they mean that the database can be restored to a clean copy even after erroneous operations are performed. They are crucial for recovering from database server crashes; by rolling back any transaction which was active at the time of the crash, the database is restored to a consistent state.

The rollback feature is usually implemented with a transaction log, but can also be implemented via multiversion concurrency control.

Cascading rollback[edit]

A cascading rollback occurs in database systems when a transaction (T1) causes a failure and a rollback must be performed. Other transactions dependent on T1's actions must also be rollbacked due to T1's failure, thus causing a cascading effect. That is, one transaction's failure causes many to fail.

Practical database recovery techniques guarantee cascadeless rollback, therefore a cascading rollback is not a desirable result.

SQL[edit]

In SQL, ROLLBACK is a command that causes all data changes since the last BEGIN WORK, or START TRANSACTION to be discarded by the relational database management systems (RDBMS), so that the state of the data is "rolled back" to the way it was before those changes were made.

A ROLLBACK statement will also release any existing savepoints that may be in use.

In most SQL dialects, ROLLBACKs are connection specific. This means that if two connections are made to the same database, a ROLLBACK made in one connection will not affect any other connections. This is vital for proper concurrency.

See also[edit]

References[edit]


Disclaimer

None of the audio/visual content is hosted on this site. All media is embedded from other sites such as GoogleVideo, Wikipedia, YouTube etc. Therefore, this site has no control over the copyright issues of the streaming media.

All issues concerning copyright violations should be aimed at the sites hosting the material. This site does not host any of the streaming media and the owner has not uploaded any of the material to the video hosting servers. Anyone can find the same content on Google Video or YouTube by themselves.

The owner of this site cannot know which documentaries are in public domain, which has been uploaded to e.g. YouTube by the owner and which has been uploaded without permission. The copyright owner must contact the source if he wants his material off the Internet completely.

Powered by YouTube
Wikipedia content is licensed under the GFDL and (CC) license