November 8, 2008 at 1:39 pm
I ve just rebooted the server. After it reboots SQL Services not started and i got these errors on the eventviewer. Please help me:((
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17058
Date:06.11.2008
Time:09:27:35
User:N/A
Computer:VVSTR01
Description:
initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error = 5(error not found).
Data:
0000: a2 42 00 00 10 00 00 00 ยขB......
0008: 08 00 00 00 56 00 56 00 ....V.V.
0010: 53 00 54 00 52 00 30 00 S.T.R.0.
0018: 31 00 00 00 00 00 00 00 1.......
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17053
Date:06.11.2008
Time:09:27:38
User:N/A
Computer:VVSTR01
Description:
UpdateUptimeRegKey: Operating system error 5(error not found) encountered.
Data:
0000: 9d 42 00 00 10 00 00 00 ยB......
0008: 08 00 00 00 56 00 56 00 ....V.V.
0010: 53 00 54 00 52 00 30 00 S.T.R.0.
0018: 31 00 00 00 00 00 00 00 1.......
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:9003
Date:06.11.2008
Time:10:34:41
User:N/A
Computer:VVSTR01
Description:
The log scan number (347:192: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.
Data:
0000: 2b 23 00 00 14 00 00 00 +#......
0008: 08 00 00 00 56 00 56 00 ....V.V.
0010: 53 00 54 00 52 00 30 00 S.T.R.0.
0018: 31 00 00 00 00 00 00 00 1.......
November 8, 2008 at 2:26 pm
Does the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG" exist? Is it readable?
Do you have a backup of the master database?
Can you do a check of the C drive? It looks like there's registry damage and damage to a couple of files. If so, that indicates hardware problems. Is C drive a raid array? If so, check to see if the raid controller is reporting errors
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
November 8, 2008 at 2:28 pm
Did you lose a disk or move things around? It looks like either you have a bad disk, or it moved. Is the error log back there?
Also, check the services parameters for startup. Is the master database file name path valid?
November 8, 2008 at 2:51 pm
Error.log file seems like below.
There is no raid. i donnow how can fix this ๐
2008-11-08 00:06:03.40 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)
2008-11-08 00:06:03.40 Server (c) 2005 Microsoft Corporation.
2008-11-08 00:06:03.40 Server All rights reserved.
2008-11-08 00:06:03.40 Server Server process ID is 6920.
2008-11-08 00:06:03.40 Server Authentication mode is MIXED.
2008-11-08 00:06:03.40 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2008-11-08 00:06:03.40 Server This instance of SQL Server last reported using a process ID of 5020 at 08.11.2008 00:05:56 (local) 07.11.2008 22:05:56 (UTC). This is an informational message only; no user action is required.
2008-11-08 00:06:03.40 Server Registry startup parameters:
2008-11-08 00:06:03.40 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2008-11-08 00:06:03.40 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2008-11-08 00:06:03.40 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2008-11-08 00:06:03.40 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2008-11-08 00:06:03.40 Server Detected 2 CPUs. This is an informational message; no user action is required.
2008-11-08 00:06:03.57 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.
2008-11-08 00:06:03.59 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2008-11-08 00:06:05.65 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.
2008-11-08 00:06:05.65 Server Database mirroring has been enabled on this instance of SQL Server.
2008-11-08 00:06:05.65 spid5s Starting up database 'master'.
2008-11-08 00:06:05.68 spid5s Error: 9003, Severity: 20, State: 1.
2008-11-08 00:06:05.68 spid5s The log scan number (347:192: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.
2008-11-08 00:06:05.68 spid5s 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.
November 8, 2008 at 3:00 pm
Do you have a backup of master?
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
November 8, 2008 at 3:11 pm
I ve a CRM program that uses SQL database. I ve got a backup of CRMDatabase that took with CRM Database Manager. When i restore it from CRM Database manager nothhing changes. But i vent got master db backup :(:(
November 8, 2008 at 3:23 pm
I ve get a report for backup operation of master db and see there is a backup .But i cannot see the backup in that folder. Device Type seems Disk (Temproary). Can i bring this file back?
July 6, 2009 at 12:13 pm
I've got same problem raising event 9003.
My SQLServer 2008 service wont start too.
July 6, 2009 at 1:04 pm
Do you have a backup of master? What's the exact errors that you're getting? What's in the SQL error log?
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 7, 2009 at 1:56 pm
No, i don't have master backup.
solution I came up with was to remove troubled instance and install it all over again.
but seams likely below article might have halped if i had master backup (hope someone will find it useful ๐ )
either way no harm done, luckly it was test enviroment, not production ๐
July 16, 2009 at 4:05 am
hello guys,
I am having the same problem and sql server 2005 is not starting , every solution on the web requires sql server service to be running , or require to connect to SSMS , but to connect to sql server management studio sql server service must be running, i am in terrible condition, please if you guys have any solution.. I have already treid rebuilding master database but even after that nothing is working........... please help.
This is the log file
009-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.
July 16, 2009 at 9:27 am
Do you have a backup of master?
How did you rebuild the master database and how did you verify that it really did get rebuilt?
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 17, 2009 at 12:59 am
I rebuild the master database using the command
start /wait \server\setup.exe /qn MSSQLSERVER reinstall=sql_engine rebuilddatabase=1 sapwd=mypassword
I checked the log file and it say completed succesfully .
I am desperate....
July 17, 2009 at 1:10 am
Maybe give Microsoft's customer support a shout. I've heard of a case where the rebuild says it succeeded but didn't, not sure why that could happen. Calling CSS will be a lot faster than getting free assistance here.
It isn't maybe a case where master is somewhere other than the default location and the rebuild put the new files in the default location?
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
January 15, 2010 at 7:33 am
if you haven't a backup file you must recreate log file. i tried it. it's sucsess.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply