x

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 '10 at 08:48 AM in Default

user-1451 gravatar image

user-1451
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.

Dave.

more ▼

answered Mar 31 '10 at 06:41 AM

user-1392 gravatar image

user-1392
71 1

By 'restore point' I mean Windows system restore point or an equivalent.
Mar 31 '10 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 '10 at 07:05 PM

SQLMaster gravatar image

SQLMaster
81 2

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x85
x66

asked: Mar 25 '10 at 08:48 AM

Seen: 3198 times

Last Updated: May 17 '13 at 02:08 AM