SQL Server Enterprise Edition With SA RRS feed

  • Question

  • Hi,
    We have a two node SQL Server 2016 Enterprise edition with SA using availability groups. Primary node is licensed with the secondary node in a DR state for DR.  There are no workloads on the passive/secondary server so it is totally passive. 

    I read where we could do our backups on the secondary node under SA. Is this correct?



    • Moved by Dave PatrickMVP Tuesday, January 5, 2021 6:55 PM looking for forum
    Tuesday, January 5, 2021 5:34 PM


  • I'd try asking for help over here.

    sql-server-general - Microsoft Q&A



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Tuesday, January 5, 2021 6:54 PM