Post reply

SSRS in a Basic Availability Group

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply