Important Steps to Repair SQL Server Failover Clustered Instance
Installation Repair option was provided starting with SQL Server 2008 which is helpful in many cases during installation failure. Instead of uninstalling and reinstalling multiple times, repair option allows to fix any installation problems thus avoiding lot of duplicate work. Also the repair option comes handy during installation of service packs or CUs where repair can be used to fix any major problems left after main SQL Server install. SQL Server 2005 also had repair option which can be invoked from control panel, but it was very limited and often not very helpful. Below are some important steps which can be followed to perform repair of SQL Server Failover Clustered Instance.
Steps to Repair SQL Server failover Cluster instance
– Starting with SQL Server 2008, cluster installation has changed where installation setup has to be run on all the nodes which will be part of SQL Server Failover cluster instance. So, even Repair must be run on each individual cluster nodes that is affected or damaged.
– Launch the SQL Server Setup program from SQL Server installation media by choosing Run-as-Administrator.
– Initially there there are few setup rule check performed and then the Setup will show the SQL Server Installation Center page. SQL Server Installation Center was introduced starting SQL Server 2008 which has many options related SQL Server setup.
– Click on the “Maintenance” option in the left-hand side, and then click on “Repair” option which will start the repair operation.
– Setup will run some Setup support rules and some file routines are run to ensure that the system has all the prerequisites installed and that the computer passes Setup validation rules. Click OK or Install to continue.
– On the Select Instance page, choose the SQL Server instance which has to be repaired, and then click Next to continue.
– The repair rules will be run to validate if repair can proceed further or not. To continue, click Next.
– Ready to Repair page appears which indicates that the repair operation is ready to proceed. so click on “Repair”.
– The Repair Progress page shows the status of the repair operation. Monitor for successful completion of the repair operation.
– Repeat the same operations on the other nodes as well.
– Connect to SQL Server instance from SQL Server Management Studio and verify you are able to connect.
– Verify SQL Server Errorlogs and Event Viewer Application and System logs to make sure there are no errors.
– Check the setup summary log file to make sure there are no errors reported during repair operation for any component which has been repaired.
– If the repair fails, then the only option that will be left with is to reinstall the SQL Server failover instance.
This is applicable on below versions of SQL Server
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.