need to run the backup on specific secondary server


  • Hi all,

     I have a three node AG group (node1 and node2 and node 3) . Node 3 is primary Node 1 is used for read-only. 

    I want to run the backup on only once particular Node that is Node2.

    This is unless and until we make this node2 as primary ,it is going to be manual ( so we cannot run backup) .  Till that Node 2 need to be the backup node .

    I need to keep this as standard to run backups on Node2. 

    How do i do that .. 

    Thanks & Regards



    Wednesday, April 11, 2018 2:55 AM

All replies