What is the difference between a transaction rollback and a backup restore?

SQL changing data safely · Experienced

Model answer

A rollback undoes uncommitted changes within a transaction. Once you commit, rollback is impossible, and recovery needs a backup, point-in-time recovery or a replica. This is why you test backups regularly, not just take them.

Learn this topic

INSERT, UPDATE and DELETE: Change Data Safely in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• How do you insert, update and delete rows?
• How can you make UPDATE and DELETE safer?
• What is the difference between INSERT ... SELECT and INSERT ... VALUES?
• What is an upsert?
• How do you add a column or change a table?
• What are default values and auto-increment/identity columns?