Rebuilding the master Database

I have a copy of SQL Server Express on a clients computer.

When i try & restart the services it fails with the following error:-

Error: 9003, Severity: 20, State1.

It looks like the master database has become corrupt & needs rebuilding.

I have found a utility rebuildm.exe that repairs the master db but unfortunately it is not supported in sql 2005.

Does anyone have any other suggestions on how to repair the master db.

Thanks.

i think this will help u

http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx

Madhu

|||

Rebuildm.exe is used in sql 2000 .....i think you can rebuild as below,

copy the sql server express exe file to your local hard disk and then in cmd go to relevant path where the setup file resides and run the below code in command prompt.........

start /wait <CD or DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<NewStrongPassword>

This works with sql 2005 and i think it will work with sql express also.........pls correct me if am wrong

Thanxx

Deepak

|||

Thanks for that.

Silly question but will the instance name be master & will the SAPWD be sa also do you think i need to use < > between instancename & sa

Does this look good to you guys.

setup.exe /qn INSTANCENAME=<master> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<sa>

|||

Go to the appropriate path where your sql server setup.exe exist in the command prompt........I assume its in C:\test folder .......then command will be like this,

C:\Test> start /wait \setup.exe /qn INSTANCENAME="SQLEXPRESS" REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD="XXXXX"

SQL Server Express always installs a named instance (SQLExpress) unless you select a default instance.

http://technet.microsoft.com/en-us/library/ms143744.aspx

I am not sure if this is correct just try|||

Thanks guys.

Got it to work.

Respect.