log backup on secondary

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  October 15, 2015 at 5:44 am

  #399189

  can we take log backup on secondary replica in always on ?

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  October 15, 2015 at 6:09 am

  #1833450

  Yes.

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  October 15, 2015 at 6:16 am

  #1833455

  thanks .. can you send the query ?

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  October 15, 2015 at 6:32 am

  #1833460

  BACKUP LOG **DBNAME** TO DISK = '**PATH TO WHERE YOU WANT THE LOG TO BE STORED**'

  https://msdn.microsoft.com/en-us/library/hh245119.aspx?f=255&MSPPError=-2147217396