Hi Ken,

Did you manage to solve this problem? What is the solution?

I have the same problems, but mine started after a hard drive failure on my RAID 5, a corrupted System Registry Hive and a few other problems in between.

When I finally had everything restored/fixed up so that I can boot into the server, everything was working besides SQL.

In the mean time I'll try the chkdsk again and the defrag option, as I had some problems with the file system during this whole process.

Is there a way of restoring another temp db using another sql server instance to replace the one on the server that is currently experiencing problems?

Running Windows 2003 R2, SP2.

SQL Server 2000 MSDE SP4 (Version: 8.00.2039)

Any help would be appreciated.

Thank you.

Kobus