"Sue Hoegemeier" wrote:

> Check the disk space, run diagnostics on the disk and make
> sure the permissions are set correctly on the directory. See
> the following articles for more info:
> http://support.microsoft.com/?id=239759
> http://support.microsoft.com/?id=313702
>
> -Sue
>
> On Mon, 20 Mar 2006 17:13:27 -0800, Inalt
> <Inalt@discussions.microsoft.com> wrote:
>
> >I have MSSQL2K SP3 running as a back end for WSS. After rebooting the machine
> >the server won't start with an log error below when I attempt to start the
> >service. Please help!
> >
> >==========
> >2006-03-20 17:07:07.12 server Microsoft SQL Server 2000 - 8.00.2039
> >(Intel X86)
> > May 3 2005 23:18:38
> > Copyright (c) 1988-2003 Microsoft Corporation
> > Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
> >
> >2006-03-20 17:07:07.12 server Copyright (C) 1988-2002 Microsoft
> >Corporation.
> >2006-03-20 17:07:07.12 server All rights reserved.
> >2006-03-20 17:07:07.12 server Server Process ID is 1944.
> >2006-03-20 17:07:07.12 server Logging SQL Server messages in file
> >'d:\Mssql2k\MSSQL\log\ERRORLOG'.
> >2006-03-20 17:07:07.17 server SQL Server is starting at priority class
> >'normal'(2 CPUs detected).
> >2006-03-20 17:07:07.25 server SQL Server configured for thread mode
> >processing.
> >2006-03-20 17:07:07.28 server Using dynamic lock allocation. [2500] Lock
> >Blocks, [5000] Lock Owner Blocks.
> >2006-03-20 17:07:07.39 server Attempting to initialize Distributed
> >Transaction Coordinator.
> >2006-03-20 17:07:09.99 spid2 Starting up database 'master'.
> >2006-03-20 17:07:10.29 server Using 'SSNETLIB.DLL' version '8.0.2039'.
> >2006-03-20 17:07:10.31 spid5 Starting up database 'model'.
> >2006-03-20 17:07:10.34 spid2 Server name is 'FILESERVER'.
> >2006-03-20 17:07:10.37 spid8 Starting up database 'msdb'.
> >2006-03-20 17:07:10.38 spid9 Starting up database 'pubs'.
> >2006-03-20 17:07:10.38 server SQL server listening on 192.168.100.202:
> >1433.
> >2006-03-20 17:07:10.38 server SQL server listening on 127.0.0.1: 1433.
> >2006-03-20 17:07:10.43 spid10 Starting up database 'Northwind'.
> >2006-03-20 17:07:10.46 spid11 Starting up database 'sharepoint'.
> >2006-03-20 17:07:10.48 spid12 Starting up database
> >'STS_fileserver_1414639615'.
> >2006-03-20 17:07:10.56 server SQL server listening on TCP, Shared Memory,
> >Named Pipes.
> >2006-03-20 17:07:10.56 server SQL Server is ready for client connections
> >2006-03-20 17:07:10.81 spid5 Clearing tempdb database.
> >2006-03-20 17:07:10.93 spid5 Encountered an unexpected error while
> >checking the sector size for file 'd:\Mssql2k\MSSQL\data\tempdb.mdf'. Check
> >the SQL Server error log for more information.
> >2006-03-20 17:07:11.37 spid5 CREATE DATABASE failed. Some file names
> >listed could not be created. Check previous errors.
> >2006-03-20 17:07:11.37 spid5 WARNING: problem activating all tempdb
> >files. See previous errors. Restart server with -f to correct the situation.
>