troubleshooting Question

SQL Server 2005 stopped and can't be started

Avatar of dave_sky
dave_skyFlag for United States of America asked on
Microsoft SQL Server 2005
7 Comments3 Solutions508 ViewsLast Modified:
Hope someone can help.

Have been using this server for several years with no problems.

Tried restarting in Services and configuration manager...

Here is the sql error log file:
2011-05-19 14:07:25.39 Server      Microsoft SQL Server 2005 - 9.00.3080.00 (Intel X86)
      Sep  6 2009 01:43:32
      Copyright (c) 1988-2005 Microsoft Corporation
      Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

2011-05-19 14:07:25.39 Server      (c) 2005 Microsoft Corporation.
2011-05-19 14:07:25.39 Server      All rights reserved.
2011-05-19 14:07:25.39 Server      Server process ID is 3472.
2011-05-19 14:07:25.39 Server      Authentication mode is WINDOWS-ONLY.
2011-05-19 14:07:25.39 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2011-05-19 14:07:25.39 Server      This instance of SQL Server last reported using a process ID of 2816 at 5/19/2011 2:06:01 PM (local) 5/19/2011 9:06:01 PM (UTC). This is an informational message only; no user action is required.
2011-05-19 14:07:25.39 Server      Registry startup parameters:
2011-05-19 14:07:25.39 Server             -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2011-05-19 14:07:25.39 Server             -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2011-05-19 14:07:25.39 Server             -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2011-05-19 14:07:25.39 Server      Error: 17113, Severity: 16, State: 1.
2011-05-19 14:07:25.39 Server      Error 2(The system cannot find the file specified.) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.
Paul Jackson
Software Engineer
Join our community to see this answer!
Unlock 3 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros