Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Right,

I powered off development server because it was hanged, when restarted directory services database was corrupted, so fixed it, then figured out that IIS Manager's metadata.xml is messed up, so fixed it using backup too.

But now SQL Server service isn't starting giving this error,

Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

Right I already tried adding network service permission to all files and databases still no luck, i also read after googling that compressing it might work but it don't know what they mean.

How can I fix it ?

I tried

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap>start /wait setup.exe /
qb InstanceName=MSSQLSERVER SQL_Engine REBUILDDATABASE=1 SAPWD=mypassword REINST
ALLMODE=omu

and

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap>start /wait setup.exe /
qb  /action=rebuilddatabase /quiet /InstanceName=MSSQLSERVER /sqlsysadminaccount
s=domainName\userName /sapwd=123

but no gain only pain.

share|improve this question
1  
I see you have already restored an out-of-date master.mdf from this question: dba.stackexchange.com/questions/50336/… –  Max Vernon Sep 23 '13 at 13:25
    
I have seen both of your posts on your problems with "master" db. You state in the other post that pasting in a older master.mdf copy got you up and running. When did the "Cannot restore master" error begin? After you tried to straighten out your directory service and IIS Manager? What changed? –  RLF Sep 23 '13 at 18:40
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.