question

user-1451 avatar image
user-1451 asked

Error during SQL Server 2008 installation: A severe error occured on the current command. The result, if any, should be discarded

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.

sql-server-2008clusterinstallation
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

user-1392 avatar image
user-1392 answered

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:

  1. install DPM so you can restore the complete machine images;
  2. install a UPS so power fail is less likely.

Dave.

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

By 'restore point' I mean Windows system restore point or an equivalent.
0 Likes 0 ·
SQLMaster avatar image
SQLMaster answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.