asked on

SQL Server 2000 Crash

Hi Experts,

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!!!

Thank You

skarai

You are correct SQL 2000 needed model DB to be intact to start up Temp DB without it SQL cant start correctly. Thankfully you can rebuild/recreate model from the install media. Unfortuantley I dont have install media for SQL 2000 at thsi time but the respective DB creation scripts should be on there.

Aanvik

ASKER

Hi,
Thank you for your reply. I don't have install media either. So is there any way I can rebuild Model and TempDB database?

Thx

skarai

You dont need to worry about rebuilding temp db as it will be rebuild once model DB is back and functioning. If you have another SQL 2000 server around with model DB files in the same location you can try swapping the known good files in place of your corrupt files while SQL server is still down. Lesson to take away from this is the critical task of backing up your system DBs master, mdoel and msdb for SQL 2000 platform.

Aanvik

ASKER

I have the model DB backup but it won't restore as to restore it needs tempdb.

ASKER CERTIFIED SOLUTION

Scott Pletcher

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

skarai

This KB should get you back on track - first start SQL so it only recovers master DB - then restore model db from backup. http://support.microsoft.com/kb/822852