Forum Discussion

Pillalamarri Venkateswara Rao's avatar
Pillalamarri Venkateswara Rao
Copper Contributor
Apr 17, 2018

PSCONFIG.EXE - What are all the database this command line is going to touch?

Hi Team,

 

What are all the databases  PSCONFIG.EXE command is going to touch? My problem is we set up availability group on SQL Databases. So, we are not sure for which databases we need to remove the availability groups. Thanks in advance!

 

-

Regards,

Venkat

admin
powershell
SharePoint 2016

2 Replies

Sort By
  • Trevor Seward's avatar
    Trevor Seward
    MVP
    Apr 19, 2018
    The only database that should never be part of an AOAG is the Usage database. The data is transient, the database has high I/O due to frequent data imports, and there is no impact to farm availability if the database becomes unavailable.

    If the Usage db is part of an AOAG, psconfig/Config Wizard will fail to complete.
    • Pillalamarri Venkateswara Rao's avatar
      Pillalamarri Venkateswara Rao
      Copper Contributor
      Apr 19, 2018

      Hi Trevor,

       

      Thank you! But actually, I see for WSS_Logging as well. So that is the reason I am curious to know the list of the databases. Here is the error message related to WSS_Logging database as well. Any suggestion, please?

       

      "An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: The operation cannot be performed on database "WSS_Logging" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.
      ALTER DATABASE statement failed."

Resources