Daily Archives: September 26, 2011

Recovery Models

In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find that most databases use the defaults, which mean that they are in the full recovery model. In that case, you need to be … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on Recovery Models

Probabilities and Disaster Recovery

When I talk about disaster recovery, one of the key things that I try to stress is the idea that the amount of effort and resources you devote to the problem is often scaled to the risk of loss. It … Continue reading

Posted in Editorial | Tagged | Comments Off on Probabilities and Disaster Recovery