Tag Archives: sql server

SQL Server Recovery–MCM Prep

Posted on January 31, 2011 by way0utwest

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

Posted on January 25, 2011 by way0utwest

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

Disk Partition Alignment–MCM Prep

Posted on January 21, 2011 by way0utwest

Does disk partition alignment matter to SQL Server? Without a doubt. When new disk partitions are created, there could be a reserved set of sectors that could differ across disks because of the way that the hardware interacts. In the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Disk Partition Alignment–MCM Prep

You Need Two SLAs for Disaster Recovery

Posted on January 18, 2011 by way0utwest

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