Could Installing SQL 2005 SP1 Have Been a No-No If Your Server Dies

[domw001]

I am in a DR senario and I am having trouble rebuilding the system databases on my SQL 2005 cluster.

I run the following string (because MS has decided to remove Rebuildm.exe):

start /wait setup.exe /qn VS=Vname INSTANCENAME=instname
REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=password
SQLACCOUNT=domain\acct SQLPASSWORD=password AGTACCOUNT=domain\acct
AGTPASSWORD=password REINSTALLMODE=vomus


The setup fails with the following error:

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 1
(Build 3790)
Time : Wed Dec 13 15:41:44 2006

CLUSTERSVR1 : To install Microsoft SQL Server 2005, COM+ should work.
CLUSTERSVR1 : To change an existing instance of Microsoft SQL Server 2005 to
a different edition of SQL Server 2005, you must run SQL Server 2005 Setup
from the command prompt and include the SKUUPGRADE=1 parameter.
CLUSTERSVR1 : To install Microsoft SQL Server 2005, COM+ should work.
CLUSTERSVR1 : To change an existing instance of Microsoft SQL Server 2005 to
a different edition of SQL Server 2005, you must run SQL Server 2005 Setup
from the command prompt and include the SKUUPGRADE=1 parameter.
Machine : CLUSTERSVR1
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Error Number : 5897

Basically the SP1 version of Sqlservr.Exe is treated as a different version.




SQL 2005 was originally installed in May '06 as RTM.
SP1 applied in September '06.

I have the original RTM install disk but obviously SP1 is causing rebuild to fail.

The SKUUPGRADE option failed because I cannot "upgrade" to a lower level version.

I dont want to uninstall/reinstall SQL.

Is there a way round this or have Microsoft dropped the ball spectacularly with SQL DR?

 

[Catadmin]

I'm curious. What happened that you felt the need to rebuilt the system dbs?

I'm not sure what your problem is, but I do know there was a Post SP1 Hot Fix for SQL Server 2k5. This may be the cause of your problem. Have you tried installing that?

In any event, you may have to contact Microsoft Support if you've already irrevocably altered the SQL Server install. Especially if you don't want to try uninstalling and reinstalling.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

What's your DR senerio? What's your DR stragity?

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com