David Svedarsky
asked on
SQL Server 2005 stopped and can't be started
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\E RRORLOG'.
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\E RRORLOG
2011-05-19 14:07:25.39 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ mastlog.ld f
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.
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\E
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\
2011-05-19 14:07:25.39 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\E
2011-05-19 14:07:25.39 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
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\
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
master.mdf is the data file for the master database which is a system database that is required for all sql server installs it contains information about all other databases in the instance.
http://www.techrepublic.co m/article/ explore-ho w-sql-serv ers-system -databases -work/6105 067
http://www.techrepublic.co
ASKER
the master file is in the correct path.......must be corrupted. I have a working master file on another pc that is ok. I copied it to the problem pc and it still didn't work.
The link above gives some good information, but is outdated: My pc does not contain the Rebuild file.
Any more ideas?
The link above gives some good information, but is outdated: My pc does not contain the Rebuild file.
Any more ideas?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Should the path be 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\
Where would I go to change the path to MYDATABASE.mdf?