Tag Archives: mcm

T Minus Three Days to the MCM Test

Posted on February 22, 2011 by way0utwest

I take the MCM test on Friday. I’ve been watching videos and reading white papers and blogs for the last few weeks and I know that I don’t necessarily know enough. To some extent I have an advantage since I … Continue reading →

Posted in Blog | Tagged , | Comments Off on T Minus Three Days to the MCM Test

Backups after a DR Restore – MCM

Posted on February 21, 2011 by way0utwest

If you have a disaster, and you need to restore to some point in time prior to the last log backup you have, what’s the first thing you should do at this point in time? Make a full backup, of … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Backups after a DR Restore – MCM

A Full Backup can Impact a Log Backup–MCM Prep

Posted on February 2, 2011 by way0utwest

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

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