January 24, 2010 at 12:26 am
I have a copy of SQL Server 2005 ent
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 rebuild.
i am having master DB backup.but first i need to recover the sql services then i will be able to restore master DB.
i have put this below command but nothing is happened.
start /wait setup.exe /qn INSTANCENAME=sqltestting REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=abc*1234
even the database does not come into emergeny mode.
i tried to follow the microsoft doc but no success.
http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx
Does anyone have any other suggestions on how to repair the master db through setup.exe
also please tell me is there any third party tool available to resolve this issue.
January 31, 2010 at 2:01 am
Hi,
Please go thru below post this is perfact example of restoration of Master Database in SQL 2005.
http://geekswithblogs.net/travis/archive/2005/07/27/48400.aspx
Regards
GURSETHi
February 22, 2010 at 4:56 am
Rebuild must be done in single user mode.
“\Program File\Microsoft SQL Server\MSSQL.1\MSSQL\BINN\sqlservr.exe" -m
Start a DOS box:
C:\> sqlcmd
Restore database master from DISK = ‘\Path of backup file .bak'
- SAMJI
If you marry one they will fight with you, If you marry 2 they will fight for you 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply