August 22, 2019 at 8:25 am
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.
August 22, 2019 at 2:49 pm
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/
August 23, 2019 at 8:21 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply