Norman Bauer

… just technical stuff!

Error while running SharePoint 2010 Products Configuration Wizard

The wizard aborts at about 10% in step 9. Everything I could find in the logs was this here:

Unknown SQL Exception 1468 occurred. Additional error information from SQL Server is included below.

The operation cannot be performed on database “Sharepoint2010_UsageDB” 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.

Seems legit to me, since I moved all databases to a SQL Server 2012 Always On environment…

Technet says:

We do not recommend that you mirror the Usage and Health Data Collection Logging database. A SharePoint environment can continue to run if this database fails, and this data can be quickly regenerated.

So I removed the Usage DB from the Always On Availability Group, ran the wizard again and it worked.

Posted under: Events, Sharepoint Server, SQL Server

Tagged as: , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>