High Availability Practice

  • Hi,

    I've been SQL Server DBA for about a year of 5 small databases.

    I've read about high availability and I'd like to practice with this feature.

    I understand that no one is going to hand me their precious information just for practice. 😀

    My question is: what is a good way or place to practice this feature?

    Should I create sql server databases in Azure and create traffic?

    Are there training courses for these?

    What's your advice?

    Thanks.

  • VMs in Azure work well, not the hosted SQL DB (can't set up availability groups on those)

    How to practice: Set it up with a sample DB (AdventureWorks or WideWorldImporters) and break one of the servers and see if you can recover.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks for the advice GilaMonster.

    I'll keep that in mind for when the time comes.

  • oscarDBA (11/2/2016)


    Hi,

    I've been SQL Server DBA for about a year of 5 small databases.

    I've read about high availability and I'd like to practice with this feature.

    I understand that no one is going to hand me their precious information just for practice. 😀

    My question is: what is a good way or place to practice this feature?

    Should I create sql server databases in Azure and create traffic?

    Are there training courses for these?

    What's your advice?

    Thanks.

    Work through my stairway to AlwaysOn starting at this link

    http://www.sqlservercentral.com/stairway/112556/[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply