missing server roles

[collierd2]

Hi

I am using SQL 2000

I can't really describe this any other way, so will start like this

Over the weekend our SQL server was rebooted (routine maintenance)
Upon restarting, all the server roles have disappeared and, upon investigation a number of elements of the master database have become corrupt

We have tried restoring (recent and old backup)
Neither restoration resolved the issue

Has anybody ever seen anything like this?

Thanks

Damian.

 

[mrdenny]

That's a new one.

If you can't restore the master database then you basically have three options.

Use the rebuildm.exe and rebuild the master database, move the databases to another server, call Microsoft had have them walk you through option 1 or option 2.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog