Understanding SQL Server Recovery Models and Transaction Log Use
In this tip we look at how the SQL Server database recovery model impacts how the transaction log is used and grows.
Recovery Models
Don’t miss these valuable tips, tutorials, how-to’s, scripts, and more on SQL Server Recovery Models ideal for SQL Server DBAs.
Indirect Checkpoints in SQL Server 2012
SQL Server 2012 has many new features and the Indirect Checkpoints feature is an interesting option to allow you to control the recovery time for a database. In this tip we will explore the use of this new feature and the steps to configure this option.
Database recovery model change notification report for SQL Server
The database recovery model plays a crucial role for the recovery of a database. With several DBAs having access to a SQL Server instance there are bound to be changes that are not communicated. In this tip we cover a monitoring solution we deployed at
SQL Server Database Recovery Models for Proper Backup Plan
One of the first things that should be done when managing SQL Server is to setup an appropriate backup plan in order to minimize any data loss in the event of a failure. Along with setting up a backup plan there are certain database configurations that n