July 6, 2012 at 6:41 am
As per the topic,
I can't seem to start my SQL services. It always give me this error. Any expert out there can help me?
July 6, 2012 at 6:59 am
junlong_9292 (7/6/2012)
As per the topic,I can't seem to start my SQL services. It always give me this error. Any expert out there can help me?
What error do you get in the SQL Server error log file?
July 6, 2012 at 7:08 am
Hi Divine flame,
Thanks for your reply
this is the error i got when i tried to connect my SQL
July 6, 2012 at 7:10 am
What's in the SQL Server error log?
Those errors are meaningless, to see why the service won't start, we need to see the actual errors, which are in the error log. Just post the entire of the latest log file here (as text, not a screenshot)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2012 at 7:17 am
Hi GilaMonster
Thanks for replying
this is the error
2012-07-06 20:11:42.22 Server Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
Dec 10 2010 10:56:29
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
2012-07-06 20:11:42.22 Server (c) 2005 Microsoft Corporation.
2012-07-06 20:11:42.22 Server All rights reserved.
2012-07-06 20:11:42.22 Server Server process ID is 7508.
2012-07-06 20:11:42.22 Server Authentication mode is WINDOWS-ONLY.
2012-07-06 20:11:42.22 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2012-07-06 20:11:42.22 Server This instance of SQL Server last reported using a process ID of 6556 at 06/07/2012 7:51:36 PM (local) 06/07/2012 11:51:36 AM (UTC). This is an informational message only; no user action is required.
2012-07-06 20:11:42.23 Server Registry startup parameters:
2012-07-06 20:11:42.23 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2012-07-06 20:11:42.23 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2012-07-06 20:11:42.23 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2012-07-06 20:11:42.23 Server Error: 17113, Severity: 16, State: 1.
2012-07-06 20:11:42.23 Server Error 2(error not found) 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.
July 6, 2012 at 7:48 am
junlong_9292 (7/6/2012)
2012-07-06 20:11:42.23 Server Error 2(error not found) 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.
Is the file there? Don't think so.
Locate the master.mdf in your disk and change the startup parameters in the Configuration Manager.
If the file was lost, restore from backup.
-- Gianluca Sartori
July 6, 2012 at 7:57 am
Hi,
May i ask will re-install solve this problem. If not, do i do system restore to the recent image or the most furthest one?
thanks
July 6, 2012 at 8:27 am
yes, a reinstall of SQL Express will solve the issue, but that's a little extreme.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply