My Study Guide for the 462 exam, free to you

  • It's almost time to take the 462 exam and get a step closer to MSCE. Like with 461, I am leaving a little bread trail that I can find in the future for reference, and again, its free to you.

    (This study guide will be updated continuously until I take the exam)

    This exam is much different than the 461 and requires a different depth of knowledge, mostly related to Server Administration. I find myself doing a lot of non-SQL related steps in order to prepare a proper lab in my bedroom for studying.

    The goal is to set up a complete simulated enterprise, including clustered failover Windows Server, Domain, and Clustered SQL databases, using my 2 personal home computers. I want to utilize the latest technologies that I expect commercial enterprise will desire in the future, such as Hyper-V. You know if someone asks for clustered database work, clustered windows servers will be right alongside it. Failover Cloud Redundancy is a big trend of the day.

    I went ahead and dedicated 1 of my computer solely to this lab, installing a fresh 180 evaluation copy of Windows Server 2008 R2 Standard.


    Steps to set up lab [Before SQL Cluster Installations] (in-progress)

    Noteworthy roadblocks

    • Primary SQL Database Cluster cannot be installed on the Domain Controller.
    • Clusters require domain service accounts.
  • Thks

  • Thks for the Help :) It's going to be a little hard to achieve what you've done because I only have one PC

    I'm going to try it with virtual machines

  • I have just set up my lab using VMware. Since I only have one PC at home, I have no choice but use VMware. My pc really struggles when I fire up three sessions of windows 2008 R2 so i am upgrading to 8 gb RAM this week. I am also looking into buying SSD but not sure if it will work for me. Any ideas?