Cold backup, hot backup, and warm backup recovery

What is cold backup, hot backup, warm backup recovery?

- Cold backup is a recovery technique, in which the files must be backed up before the database is restarted at the same time.

- Hot backup is a recovery technique for each table space and is taken at the time of accessing and running the database.

- Warm back is a recovery technique where all the tables are locked and users cannot access at the time of backing up data. The backup operations can be postponed in case the users are accessing the database.
What is 2 phase commit?
What is 2 phase commit? - Distributed transactions are performed by relational databases...
Different types of resultset in JDBC
JDBC Resultset Types - Resultset contains results of the SQL query. There are 3 basic types of resultset...
Different transaction Isolation levels in JDBC
JDBC Isolation levels - Transaction Isolation levels is used to implement locking. They decide how one process isolated from other is. We have four ...
Post your comment