SQL Server 2000 Crash
Posted on 2011-10-27
I'm having trouble with one of my SQL Server 2000 box. The server was crashed and upon restart it won't recognize the model database. I tried to open SQL Server inp single user mode (command prompt) and able to access master database but without model database.
I tried to detach and restore model database, but it won;t restore as failed with error message "The operation neeps tempdb.". SO it seems like model and tempdb are not available on the server. I can not reinstall the sql, but need it up and running ASAP.
Any help would be greatly appreciated!!!