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.

more ▼

asked Mar 25, 2010 at 08:48 AM in Default

avatar image

21 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.


more ▼

answered Mar 31, 2010 at 06:41 AM

avatar image

71 1

By 'restore point' I mean Windows system restore point or an equivalent.

Mar 31, 2010 at 06:43 AM user-1392
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered May 07, 2010 at 07:05 PM

avatar image

81 1 2 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 25, 2010 at 08:48 AM

Seen: 3845 times

Last Updated: May 17, 2013 at 02:08 AM

Copyright 2018 Redgate Software. Privacy Policy