MS SQL Server 2005 Express rebuild master DB problem
Posted
by PaN1C_Showt1Me
on Server Fault
See other posts from Server Fault
or by PaN1C_Showt1Me
Published on 2010-06-03T13:07:44Z
Indexed on
2010/06/03
13:14 UTC
Read the original article
Hit count: 506
Hi !
There has been a power loss on our server and i cannot start the SQL service because the master DB is corrupted (as the log states).
I found many articles recommending running the setup.exe with optional parameters: This is what I did:
- I've downloaded
SQLEXPR32.EXE
from MS page and ran it
The first problem was, that it extracted all the setup files and started the default installation procedure. (which was unuseful for me as I need those params). If I canceled it, all the extracted files disappeared. That's why I decided to copy the extracted files somewhere and than cancel the default installation.
Now I'm trying to run the setup.exe from the extraction:
setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=xxxxx
it asks me if I want to rewrite the system db, which is what I need, but then while installing I get this error:
*An installation package for the product Microsoft SQL Server 2005 Express Edition cannot be found. Try the installation again using a valid copy of the installation package 'SqlRun_SQL.msi'*
Then it tries to install something and it states: cannot install because the same instance name already exists. But I don't want to install a new instance ..
Any idea how to solve this, please?
Thank you in advance !
© Server Fault or respective owner