Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  MSDE (2000)  MSDE won't start :-(

Author  Topic  nesses Starting Member 1 Post Posted - 2005-11-26 : 04:36:23 I need some help please. My MSDE database won't start after a reboot. This is a SurfControl MSDE database. It wasn't too healthy yesterday when the log on the SurfControl MSDE database filled so I truncated it and shrunk the file. Everything was cool until I rebooted the server today:-( Trying to start the service it says "the system cannot find the file specified" - ok to that and it says "An error 2 (the system cannot find the file specified" occured while performing this service operation on the mssqlserver service " sqlserver.exe -c -f gets this result 2005-11-26 20:00:03.28 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4) 2005-11-26 20:00:03.30 server Copyright (C) 1988-2002 Microsoft Corporation. 2005-11-26 20:00:03.32 server All rights reserved. 2005-11-26 20:00:03.32 server Server Process ID is 3636. 2005-11-26 20:00:03.32 server Logging SQL Server messages in file 'D:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'. 2005-11-26 20:00:03.35 server Warning: -f command line flag used...minimal server configured. 2005-11-26 20:00:03.35 server SQL Server is starting at priority class 'normal'(2 CPUs detected). 2005-11-26 20:00:03.46 server SQL Server configured for thread mode processing. 2005-11-26 20:00:03.46 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks. 2005-11-26 20:00:03.60 server MS DTC initialization skipped because of start up option. 2005-11-26 20:00:03.60 server ksconsole: Could not initialize console operation. 2005-11-26 20:00:03.61 server Error: 17822, Severity: 16, State: 1 2005-11-26 20:00:03.61 server Could not load Net-Library 'SSNETLIB'.. 2005-11-26 20:00:03.61 spid4 Warning ****************** 2005-11-26 20:00:03.61 server Error: 17059, Severity: 18, State: 0 2005-11-26 20:00:03.61 server Operating system error 0: The operation completed successfully... 2005-11-26 20:00:03.61 spid4 SQL Server started in single user mode. Updates allowed to system catalogs. 2005-11-26 20:00:03.63 server Unable to load any NETLIBs. Server shutting down.2005-11-26 20:00:03.63 spid4 Starting up database 'master'. Any ideas? I reall need to get it working. I don't think there are any backups