Rebuilding the master Database

• Ganners

  SSChasing Mays

  Points: 636

  More actions

  August 23, 2007 at 2:39 am

  #373294

  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.

• Andras Belokosztolszki

  SSC-Insane

  Points: 21971

  More actions

  August 23, 2007 at 2:59 am

  #728819

  This has changed for SQL Server 2005. You now need to use the setup to rebuild system databases. See http://msdn2.microsoft.com/en-us/library/ms143269.aspx

  Regards,

  start /wait setup.exe /qn REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=-New SA Password-

  More details on setup are on:

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/df40c888-691c-4962-a420-78a57852364d.htm

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software