I had SQL Server 2008 running on a Windows Server 2003 machine in a Failover Cluster setup. Due to unplanned power outage, the cluster infrastructure failed and I had to recreate the cluster. I uninstalled SQL Server 2008 on the primary node and have been trying to reinstall it on the same machine (using the same installer) but the installation process triggers the error: "A severe error occured on the current command. The result, if any, should be discarded". I have also tried to install SQL Server 2008 in stand-alone on the secondary node and I still get the same error. As a result, the Management Studio cannot connect to the database engine. Please note that this is not the first time I've had to recreate the cluster after similar unplanned failure but this is the first time I can't successfully reinstall SQL SErver 2008. Has anyone encountered a similar situation? Please kindly advise on the way forward.
I'd recommend you go back to the most recent restore point before the crash. SQL should start in emergency mode, in which case restore from most recent database backups. If SQL won't start up, go back to the restore point again, uninstall and install, then restore.
Recommendations for the future:
answered Mar 31, 2010 at 06:41 AM
Recently I bumped into similar situation while reinstalling SQL Server 2008 on a clustered environment.
The actual problem is previous UN-installation hasn't finished properly in order to let the fresh install to proceed. As suggested above you must obtain a preventive measure to avoid the recurrence.
To resolve the issue I have evicted the node and ensured to remove reference of previous SQL installation, then joined the node back to cluster...rest to install SQL.
answered May 07, 2010 at 07:05 PM