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: 549
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.EXEfrom 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