Tag Archives: Backup/Recovery

A Full Backup can Impact a Log Backup–MCM Prep

In the early days of SQL Server you could not run a log backup while a full backup was running. In fact,you tried to schedule them apart from each other early in my career to prevent collisions. Nothing bad happens, … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

SQL Server Recovery–MCM Prep

I always have to think about what happens during the recovery process in SQL Server after a restore. I’ve always known the process as roll forward and roll back, which is how the items are noted in the SQL Serve … Continue reading

Posted in Blog | Tagged , , | 1 Comment

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

The Institute for Backup Trauma

This is an editorial reprinted from April 27, 2005. It’s viral marketing, but it’s not bad. Livevault produced a short video starring John Cleese as the director for this institute that seeks to counsel those that have had problems with … Continue reading

Posted in Editorial | Tagged , , , | Comments Off on The Institute for Backup Trauma