Secondary replica in AG

  • in my secondary server the database which is in restoring state , when i checked in always on dash board "This secondary database is not joined to the availability group" , how to fix the issue as the alwya son is configured in asynchronous mode

  • first you'll need to check that the secondary has been restored to the appropriate point in time then join it to the availability group

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • The secondary database is showing in restoring and i didnt find any in logs

  • how long has the db been sitting there restoring, if you're unsure initiate a fresh copy of the primary database and replace the secondary

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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