SSRS in a Basic Availability Group

• Sporidium

  SSCommitted

  Points: 1550

  More actions

  February 28, 2020 at 5:56 pm

  #3729665

  Hi

  I've been asked to set up a Basic AG (BAG) to provide DR for a Reporting Services database across two servers running SQL Server 2016 Standard Edition.  I'm not aiming for anything fancy like read scale-out because I know the secondary replica isn't readable in a BAG.

  Will this work?  Do I need to set up two Basic AGs, one for the main ReportServer database and another for the ReportServerTempDB database?  (Because of the limit of one 'availability' database per BAG).

  If I did this, and configured SSRS to connect to the listener on the main database's BAG, would it be able to find the TempDB database when it's in the other BAG?

  Thanks

  Gary

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  February 29, 2020 at 6:10 pm

  #3729856

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.