Understanding SQL Server Recovery Models

Understanding SQL Server Recovery Models

The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg Larsen explains the three recovery models and what to think about when choosing a recovery model for a database. The #1 task that every DBA needs to be able to perform perfectly is to recover a database should it become corrupted for some reason. The recovery model of a database determines the options a DBA has when recovering a database.

Understanding SQL Server Recovery Models

The database recovery model controls how a SQL Server database can be backed up and restored. In this article, Greg Larsen explains the three recovery models and what to think about when choosing a recovery model for a database.

The #1 task that every DBA needs to be able to perform perfectly is to recover a database should it become corrupted for some reason. The recovery model of a database determines the options a DBA has when recovering a database. If a DBA can’t recover a database when a disaster strikes, then they better dust off their resume and start looking for a new line of work.

Part of a good database recovery plan is to first understand what recovery models are available. The recovery model of a database determines the types of database backups that can be taken, which in turn determines the different points in time in which a database can be restored.

Understanding the SQL Server Recovery Models

Each database within SQL Server has a recovery model setting. SQL Server has three different recovery models: Simple, Full, and Bulk-Logged. The recovery model setting determines what backup and restore options are available for a database, as well as how the database engine handles storing transaction log records in the transaction log.

database administration homepage cpu monitoring

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

How to Monitor Third Party API Integrations

How to best monitor your external and third party API integrations and hold partners accountable to SLAs

Key Insights from the 2020 State of SQL Server Monitoring Report.

This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This year, 971 database

Importing Performance Monitor data into SQL databases

This article explains how to import Windows Performance Monitor counter data to SQL database. Performance Monitor is an oldie but goldie tool to analyze performance problems. In this article, we will learn how we can write Perfmon counter data to a SQL database through the ODBC connection.

Using a Public Web Service to Consume SQL Server Build Numbers

Keeping SQL Server instances patched can be a time-consuming task for DBAs. In this article, Alejandro Cobar explains how he created a service in Azure that anyone can use to retrieve the build information for SQL Server.

Monitor the growth of SQL databases using the Default Trace

In this article, I have explained the default trace in SQL Server and how we can utilize it to monitor the growth of SQL databases and automate the process to get the list of SQL databases on which the auto-growth has occurred.