AOAG Secondary Checkdb

  • Super Cat

    SSCertifiable

    Points: 7316

    I'm looking into setting up a AOAG with a DR server which will have the option as NO for readable secondary.

    Under my understanding will mean I will not have to license the DR box.

    As best practise (Brent Ozar advice) indicates CHECKDB should be preformed all on nodes as they reside on different disks.

    Can CHECKDB be performed on this server with dbs stating no connection.

    If Checkdb can be performed will the server then need to be licensed.

    I imagine it will.

    • This topic was modified 10 months, 3 weeks ago by  Super Cat.
  • Michael L John

    One Orange Chip

    Points: 25929

    If the secondary is not readable, you only need to purchase SA for the server.

    Checkdb can certainly be performed on a secondary, and it's recommended to do it on a secondary.

    I'm not sure how being able to run checkdb affects your licensing.

    As usual, with all licensing questions, ask Microsoft or your software vendor.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Super Cat

    SSCertifiable

    Points: 7316

    Thanks Michael, I was under the impression that running CHECKDB could be considered Production work which will then mean the server will require a license.

    SQL licensing feels like a religion it seems to be open to interpretation.

     

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

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