3

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.

Charlieface
  • 52,284
  • 6
  • 19
  • 43
Mathematics
  • 7,314
  • 25
  • 77
  • 152

1 Answers1

1

When your system databases get corrupted you're into a bit of work here. This article explains how to rebuild your system databases: http://sql-articles.com/articles/troubleshooting/how-to-rebuild-system-databases-in-sql-server-2005/

Before you do anything tke a backup of all the existing system databases because you might have to recover something from these other databases too.

Hope this helps you out.

Sander Stad
  • 246
  • 4
  • 8