O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Evaluating Recovery Models

Recovery models determine how SQL Server uses the transaction log. On OLTP systems, the most appropriate recovery model is generally the Full Recovery model. For OLAP systems, the most appropriate recovery model is generally the simple recovery model. For most development environments, the most appropriate recovery model is usually the simple recovery model as well.

For mission-critical databases, or databases where point-in-time recovery is important, having a transaction log backed up every five minutes may be required. Policy-Based Management can be used to determine whether the appropriate recovery model is in place for each user database for each server type. Central Management Servers could be created for each ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required