Monthly Archives: February 2018

Server not showing joined to AG but primary still shows it as joined.


Symptoms –

Server is still added to the availability group if you view the primary.

When browsing to the AlwaysOn High Availability from the affected server, it shows up blank

The affected server is still in the failover cluster

The affected server still has the checkbox for being added to the Availability Group (SSCM)

Troubleshooting –

Rebooted the affected server.

Failed over Cluster resource to simulate a restart, no change.

Steps to fix –

  • Stop SQL Services on the affected node.
  • From the Primary Replica, remove the affected node from the AlwaysOn Availability Group.
  • Clear the checkbox for Enable AlwaysOn Availability Groups through SSCM, hit apply.
  • Check the checkbox for Enable AlwaysOn Availability Groups through SSCM, hit apply.
  • Start SQL services on the affected node.
  • At this point, any databases that were in the availability group will need to have T-log restores, or, in my case, need to be dropped and manually re-seeded.
  • Once all databases are seeded, verify the health of the AlwaysOn Availability Group via the dashboard.


This is literally one of the best scripts I’ve found. It’s a DISA CAT I finding for SQL 2008 R2/2012 if auto-growth of transaction logs is set to be a percentage. This quickly allows you to modify the auto-growth values. A very helpful script!

An auto-growth event is the process by which the SQL Server engine expands the size of a database file when it runs out of space. The amount by which a database file should grow is determined by the value that is set in the SQL configuration. While every organization has its own standards for this setting, however there are some widely followed best practices like for instance the auto-growth setting should not be in percent value

In this post I have put down two scripts that you can customize per your organizational standards. The first script helps you to identify the current settings and the second one can be used to update auto-growth settings. Both the scripts are targeted for all the databases by default, however you can call out the databases that you want to exclude from this change. Please make sure that you test these changes before pushing out to production servers.

Script 1: Identify…

View original post 10 more words

While trying to install a service pack on one of my systems, I ran into a server that kept exiting setup stating it was missing files from C:\Windows\Installer.  This is unfortunate as some people will actually clear out the C:\Windows\Installer directory trying to free up space.  Luckily, Microsoft has a few tools for fixing this issue.  You can either use the FixMissingMSI tool, or the FindSQLInstall.vbs script.  I prefer the FixMissingMSI tool as sometimes getting the approval to run a .vbs script can be difficult to obtain.  Both tools can be found here:

Update:  Several co-workers have asked me if there is anything that is safe to remove from this directory.  The answer is that it depends.  If you see a ton of .tmp files and they each 133MB and there’s a hundred of them, by all means delete them.  Typically .tmp files are caused by a failed download from the updates server.  Remove these without a problem, then download the actual update file that is being installed and install it manually.  This should clear up any issues like that.