Tag Archives: disaster recovery

Recovery Models

Posted on September 26, 2011 by way0utwest

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

Posted on September 26, 2011 by way0utwest

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

Quick Recovery Techniques Webinar

Posted on September 22, 2011 by way0utwest

The slides for the SQLServerCentral webinar #13 are available here on the blog. Download them from the link below Quick Recovery Techniques PPT There aren’t notes in there, but if you have questions, let me know. The recording of the … Continue reading →

Posted in Presentations | Tagged , | Comments Off on Quick Recovery Techniques Webinar

SQL Server Backups – When is it current?

Posted on September 1, 2011 by way0utwest

I saw a post recently where someone was asking about the restore sequence for a series of backups. The scenario was this: Full backup starts at 3:00am, and takes 30 minutes Log backup 1 starts at 3:05am, and takes 2 … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Server Backups – When is it current?