What Is Sql Recovery Model
A Recovery Model Is a Database Property That Controls How Transactions Are Logged, Whether the Transaction Log Requires (And Allows) Backing Up, and What Kinds...
A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available. Three recovery models exist: simple, full, and bulk-logged.
What is recovery model in SQL?
A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available. Three recovery models exist: simple, full, and bulk-logged.
How does SQL Server recovery models work?
The recovery model basically tells SQL Server what data to keep in the transaction log file and for how long. Based on the recovery model that is selected, this will also determine what types of backups you can perform and also what types of database restores can be performed.
Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.
