Tag Archives: disaster recovery

Avoiding Logging

As I have been studying more about SQL Server internals this year, one of the myths that keeps being debunked is the idea there are operations in SQL Server that are not logged. That’s not true as everything you do … Continue reading

Posted in Editorial | Tagged , | Comments Off on Avoiding Logging

Backing up the log in simple mode

Someone posted a note saying that their backups were really large and slow. So they were trying to manage their backup scheme and ensure some level of recovery.  I was going back and forth, along with others, talking about the … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

You Need Two SLAs for Disaster Recovery

Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once again surprised by something. Typically I have heard all kinds of talk for SLAs, usually in terms of network traffic. … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on You Need Two SLAs for Disaster Recovery

Data Loss or Downtime

I was watching Kimberly Tripp of SQL Skills talk recently about VLDB disasters and how to recover from them. One of the first things she said in the session was getting a damaged database back online, even without all of … Continue reading

Posted in Editorial | Tagged | Comments Off on Data Loss or Downtime