MS SQL Server boot fails

[Guest_imported]

I'm having problems restarting my SQL server database. Apparently we are have some problems with TEMPDB. Can someone help us. Here is the message:

17052 :Encountered an unexpected error while
checking the sector size for file
'd:\MSSQL\data\tempdb.mdf'. Check
the SQL Server error log for more
information.

After looking in my SQL log I found this messgage:
2001-10-19 15:35:31.59 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 1)

2001-10-19 15:35:31.59 server Copyright (C) 1988-2000 Microsoft Corporation.
2001-10-19 15:35:31.59 server All rights reserved.
2001-10-19 15:35:31.59 server Server Process ID is 2112.
2001-10-19 15:35:31.59 server Logging SQL Server messages in file 'd:\MSSQL\log\ERRORLOG'.
2001-10-19 15:35:31.59 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2001-10-19 15:35:31.71 server SQL Server configured for thread mode processing.
2001-10-19 15:35:31.71 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2001-10-19 15:35:31.76 server Attempting to initialize Distributed Transaction Coordinator.
2001-10-19 15:35:33.79 spid2 Starting up database 'master'.
2001-10-19 15:35:33.93 server Using 'SSNETLIB.DLL' version '8.0.194'.
2001-10-19 15:35:33.93 spid5 Starting up database 'model'.
2001-10-19 15:35:33.95 spid2 Server name is 'CSQLTNG1'.
2001-10-19 15:35:33.96 spid8 Starting up database 'msdb'.
2001-10-19 15:35:33.96 spid9 Starting up database 'TNGDB'.
2001-10-19 15:35:33.96 spid10 Starting up database 'CAICALDB'.
2001-10-19 15:35:33.96 spid12 Starting up database 'CAIOPRDB'.
2001-10-19 15:35:33.96 spid13 Starting up database 'CAISTADB'.
2001-10-19 15:35:33.96 spid11 Starting up database 'CAIDOCDB'.
2001-10-19 15:35:33.96 spid14 Starting up database 'CAISCHDB'.
2001-10-19 15:35:33.96 spid15 Starting up database 'CAIWMSDB'.
2001-10-19 15:35:34.28 spid5 Clearing tempdb database.
2001-10-19 15:35:34.37 spid5 Encountered an unexpected error while checking the sector size for file 'd:\MSSQL\data\tempdb.mdf'. Check the SQL Server error log for more information.
2001-10-19 15:35:34.64 server SQL server listening on TCP, Shared Memory, Named Pipes.
2001-10-19 15:35:34.64 server SQL server listening on 10.1.19.226:1433, 127.0.0.1:1433.
2001-10-19 15:35:34.64 server SQL Server is ready for client connections
2001-10-19 15:35:34.85 spid5 CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.
2001-10-19 15:35:34.89 spid5 WARNING: problem activating all tempdb files. See previous errors. Restart server with -f to correct the situation.

 

[fluteplr]

At this risk of stating the obvious.

Did you try restarting with -f as in the last line of the error message you posted?

WARNING: problem activating all tempdb files. See previous errors. Restart server with -f to correct the situation.