What Is Rollback Sql Server

Rollback is used to undo the changes made by any command but only before a commit is done. We can’t Rollback data which has been committed in the database with the help of the commit keyword.

What does rollback do in SQL?

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.

What is a server rollback?

A rollback is a return to a specific date and time based on a previous backup. This massive action affects all players on the server. When a rollback is implemented, actions in the game between time of the backup and the time the servers were stopped are erased.

Maya Lin-Takahashi

Maya Lin-Takahashi

Consumer Tech & Gadget Reviewer

Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.

Share this article
Twitter Facebook Pinterest