-
Ms Sql Server Error 9003
Hello guys, Can you please help me out,
I have a TFS server running with SQL Server 2005 installed, everything was running fine and suddenly one day the sql server is not starting, it was giving an error 3417, I rebuilt the Master database using the command :
start /wait \server\setup.exe /qn MSSQLSERVER reinstall=sql_engine rebuilddatabase=1 sapwd=mypassword , but even now I am getting the following error and sql server still could not start ,
Following is the log file :
2009-07-13 17:05:43.42 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.2845)
2009-07-13 17:05:43.42 Server (c) 2005 Microsoft Corporation.
2009-07-13 17:05:43.42 Server All rights reserved.
2009-07-13 17:05:43.42 Server Server process ID is 2716.
2009-07-13 17:05:43.42 Server Authentication mode is WINDOWS-ONLY.
2009-07-13 17:05:43.42 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2009-07-13 17:05:43.42 Server This instance of SQL Server last reported using a process ID of 308 at 7/13/2009 4:55:41 PM (local) 7/13/2009 11:55:41 AM (UTC). This is an informational message only; no user action is required.
2009-07-13 17:05:43.42 Server Registry startup parameters:
2009-07-13 17:05:43.42 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2009-07-13 17:05:43.42 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2009-07-13 17:05:43.42 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2009-07-13 17:05:43.42 Server Command Line Startup Parameters:
2009-07-13 17:05:43.42 Server /c
2009-07-13 17:05:43.42 Server /m
2009-07-13 17:05:43.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2009-07-13 17:05:43.43 Server Detected 2 CPUs. This is an informational message; no user action is required.
2009-07-13 17:05:43.56 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2009-07-13 17:05:43.57 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-07-13 17:05:44.59 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2009-07-13 17:05:44.59 Server Database Mirroring Transport is disabled in the endpoint configuration.
2009-07-13 17:05:44.59 spid4s Warning ******************
2009-07-13 17:05:44.60 spid4s SQL Server started in single-user mode. This an informational message only. No user action is required.
2009-07-13 17:05:44.60 spid4s Starting up database 'master'.
2009-07-13 17:05:44.70 spid4s Error: 9003, Severity: 20, State: 1.
2009-07-13 17:05:44.70 spid4s The log scan number (239:200:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
2009-07-13 17:05:44.70 spid4s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
Please help me .
-
Re: Ms Sql Server Error 9003
AppManager "General " MS SQL Server Health status when Scheduled Job has error ... We are running AM 9 build 9003 with MS SQL as the DB back end. ..