Forum Discussion
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 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.
If the Usage db is part of an AOAG, psconfig/Config Wizard will fail to complete.
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."