Hard Drive Failure, SQL Server won't start! 1

[jasonp45]

SQL Server 2000...I lost a drive (F) that had TempDB on it. SQL Server itself is resident on another drive which is still intact (ditto for OS - Win2003 Server NTFS). Now SQL Server won't start as it can't find the F drive. How can I point SQL Server toward a new location for TempDB without being able to start it? I'd prefer not to have to reinstall. Thanks!

 

[vongrunt]

SQL Server rebuilds tempdb (mdf and ldf) after every startup. So...

- Make F drive. If you don't have spare physical drive handy - idea! - use good ol' SUBST
- Create dummy folder(s) with the same path to tempdb as it was before crash.
- Run SQL Server. tempdb files should be created in this folder.

After that follow instructions for moving tempdb from here:

http://support.microsoft.com/kb/224071/EN-US/

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba

 

[dhoward007]

There is a way to recover the server... I just performed this today..

you go to the command line in the microsoft sql server\binn and run the sqlervr -c -f that will start the sever up .. then you must move the location of the tempdb by opening sql query analyzer and run the commands below after modifying the correct path info.

use master
go
Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'E:\Sqldata\templog.ldf')
go

 

[vongrunt]

-f startup switch - good point.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)