Recovery models in SQL Server || Full, Simple & Bulk-Logged recovery models || Ms SQL



In SQL server, we have three types of recovery models.
1) Full
2) Simple
3) Bulk-Logged

SQL Server backup and restore operations occur within the context of the recovery model of the database.

Recovery models are designed to control transaction log maintenance.

A recovery model is a database property that controls how transactions are logged, whether the transaction log requires backing up, and what kinds of restore operations are available.

Watch the full video to learn more about recovery models.

How to restore a database from backup.
https://youtu.be/sKWYB8F9mYg

:: Related Video links (Click below links to watch them) :::

a) Types of backup in sql server : https://youtu.be/zhtpwsCapn0​

b) Fullbackup : https://youtu.be/HOf7q2yF9g8​

c) Differential Backup : https://youtu.be/otZE1nZoUM8​

d) Transaction Log backup : https://youtu.be/QNeSP7bz24I

e) Tail Log backup : https://youtu.be/BYQvW3jKP0c

@Right to Learn @BK
Subscribe the channel for more videos.

Comments are closed.