August 23, 2007 at 2:39 am
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.
August 23, 2007 at 2:59 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply