Post reply

SQL 2012 newbie

  • July 19, 2015 at 10:10 am

    #302596

    Hi,

    I'm new to SQL 2012 and tasked with setting up of Alwayson. From what I have understood is the it replaces Mirroring available in SQL 2008, at the same time it is a mix of cluster and mirroring. Is the understanding correct.

    If anyone has setup the always on can you please share any links on this.

    Thanks

    Atulyan

  • July 19, 2015 at 10:50 am

    #1813548

    The mirroring is deprecated in 2012 but still available, because AlwaysON is an enterprise feature.

    http://www.brentozar.com/archive/2011/07/how-set-up-sql-server-denali-availability-groups/[/url]

  • July 19, 2015 at 4:45 pm

    #1813554

    Additionally, I think of AlwaysOn as being a little misleading. AlwaysOn by itself is not really the replacement for mirroring. AlwaysOn is more like a marketing term, like Systems Center. Within the AlwaysOn umbrella there is AlwaysOn Availability Groups (what you were referring to as replacing db mirroring) and AlwaysOn Failover Cluster Instance, which is what used to be (and sometimes still is) referred to as a SQL Server cluster or just a cluster.

    Joie Andrew
    "Since 1982"

  • July 19, 2015 at 9:13 pm

    #1813564

    Youtube AlwaysOnhow to I had created a 3 part video on always on, or even better you can go to microsoft virtual labs

    http://www.youtube.com/watch?v=BQSEjAHGCe4

    try this , btw you will need to setup a cluster

    Jayanth Kurup[/url]

  • July 20, 2015 at 7:24 am

    #1813637

    thanks everyone for your help

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

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