A user was having trouble with their DB configuration as it was hosted in a cluster. The error message indicated that this was due to the database being involved in a database mirroring session or an availability group, and that they were using version 8.6.0.192. The suggested solution was to set the DB to Full Recovery, and to disable the DAG for that DB during install and then re-enable it afterwards.
Read the entire ‘Troubleshooting DB Configuration with Version 8.6.0.192’ thread below:
Hello,
I’m still having trouble with my change DB configuration at my customer’s…
The COP server should use a DB hosted in a cluster.
When I perform the installation, the process failed to create all the needed tables and I have the following error message in the failure log :
” Failed executing SQL script ‘C:\ProgramData\Package Cache{91268585-622C-4AFB-AED2-F40891315A5E}v8.6.0.23\sqlSchema.clean.v8.6.sql’: The operation cannot be performed on database “DBWPXxxxxx" 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.”
Thank you for your help..
I have the feeling to jump from an issue to another one.. 😫
The version used is 8.6.0.192 and I cannot change.
Chances are the DB is setup in Full Recovery. The setup uses a ALTER DB command that only works when the DB is in Simple Recovery.
If you are running the SQL DB in an DAG you need to disable the DAG for that DB during install and re-enable it afterwards.
Worked flawless at two customers.
Continue reading and comment on the thread ‘Troubleshooting DB Configuration with ControlUp’. Not a member? Join Here!
Categories: All Archives, ControlUp Scripts & Triggers