Post reply

Read Only routing

  • August 2, 2022 at 9:17 pm

    #4071604

    Read only routing doesn't work when the secondary databases are in suspended mode. Is that accurate statement? I have tested it but wanted to confirm? Also, when I test the read only routing with -K flag I do see sometimes it does complain about could not open a connection to sql server? Please advise?

  • August 3, 2022 at 10:10 pm

    #4072200

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

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

  • August 4, 2022 at 7:23 am

    #4072309

    Hope it is Always on setup, any Database to read it has to be in Synchronising mode or Standby mode in log shipping. If it is suspended, the DB is not online and not ready to connect.

     

     

    Regards
    Durai Nagarajan

  • August 4, 2022 at 3:11 pm

    #4072507

    Thanks. Another question my understanding is when the secondary database are on suspend mode the log on the primary will continue to grow as it hasn’t sent the data to the ASYNC replica so I would need to make sure there is enough log space for that. Do I still need to disable the log backup or it is okay to run?

Viewing 4 posts - 1 through 3 (of 3 total)

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