January 18, 2012 at 11:26 pm
Hi all,
Seems my SQL Server master db got corrupt as i got the follwoing error.Can you please help
Computer:CMDB-DRC-BLR
Description:
Operating system error 38(Reached the end of the file.) on file "E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" during ReadFileHdr.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 27 14 00 00 18 00 00 00 '.......
0008: 0d 00 00 00 43 00 4d 00 ....C.M.
0010: 44 00 42 00 2d 00 44 00 D.B.-.D.
0018: 52 00 43 00 2d 00 42 00 R.C.-.B.
0020: 4c 00 52 00 00 00 00 00 L.R.....
0028: 00 00 ..
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:823
Date:1/19/2012
Time:11:13:11 AM
User:N/A
Computer:CMDB-DRC-BLR
Description:
The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x00000000080000 in file 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 37 03 00 00 18 00 00 00 7.......
0008: 0d 00 00 00 43 00 4d 00 ....C.M.
0010: 44 00 42 00 2d 00 44 00 D.B.-.D.
0018: 52 00 43 00 2d 00 42 00 R.C.-.B.
0020: 4c 00 52 00 00 00 00 00 L.R.....
0028: 00 00 ..
Regards,
Sachin
January 19, 2012 at 12:07 am
Have you run DBCC Checkdb as the error suggests?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 19, 2012 at 12:20 am
Just to share that i am unable to connect managment studio as SQL is not running the above errors are from eventvier application logs and below are the error which i got from sql error logs:-
SQL ERROR LOG:
2012-01-19 10:54:22.03 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2012-01-19 10:54:22.03 Server (c) 2005 Microsoft Corporation.
2012-01-19 10:54:22.03 Server All rights reserved.
2012-01-19 10:54:22.03 Server Server process ID is 7136.
2012-01-19 10:54:22.03 Server Authentication mode is MIXED.
2012-01-19 10:54:22.03 Server Logging SQL Server messages in file 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2012-01-19 10:54:22.03 Server This instance of SQL Server last reported using a process ID of 6768 at 1/19/2012 10:54:07 AM (local) 1/19/2012 5:24:07 AM (UTC). This is an informational message only; no user action is required.
2012-01-19 10:54:22.03 Server Registry startup parameters:
2012-01-19 10:54:22.03 Server -d E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2012-01-19 10:54:22.03 Server -e E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2012-01-19 10:54:22.03 Server -l E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2012-01-19 10:54:22.04 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2012-01-19 10:54:22.04 Server Detected 16 CPUs. This is an informational message; no user action is required.
2012-01-19 10:54:22.31 Server Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2012-01-19 10:54:22.45 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.
2012-01-19 10:54:22.45 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2012-01-19 10:54:22.47 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2012-01-19 10:54:24.90 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.
2012-01-19 10:54:24.90 Server Database mirroring has been enabled on this instance of SQL Server.
2012-01-19 10:54:24.90 spid5s Starting up database 'master'.
2012-01-19 10:54:24.90 spid5s Error: 823, Severity: 24, State: 5.
2012-01-19 10:54:24.90 spid5s The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0x00000000080000 in file 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
2012-01-19 10:54:24.90 spid5s Error: 17053, Severity: 16, State: 1.
2012-01-19 10:54:24.90 spid5s ReadFileHdr: Operating system error 38(Reached the end of the file.) encountered.
2012-01-19 10:54:24.90 spid5s Error: 5159, Severity: 24, State: 3.
2012-01-19 10:54:24.90 spid5s Operating system error 38(Reached the end of the file.) on file "E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" during ReadFileHdr.
Please suggest.
Regards,
Sachin
January 19, 2012 at 12:24 am
Try connecting with DAC
http://msdn.microsoft.com/en-us/library/ms189595.aspx
See if you can gain access that way.
In the meantime, do you have backups of your master database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 19, 2012 at 1:16 am
I wouldn't bother with CheckDB, just restore master from last good backup.
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 19, 2012 at 3:51 am
I feel DAC is not required as i am able to login on sever but not able to start sql server services.Secondly, situation is bad we dont' have backup available but we do have mdf and ldf available of system and user databases.Can you please let me know what's can be the cause of error and how we can overcome of this?
PLease let me know if some more information is required from my side.
Regards,
Sachin
January 19, 2012 at 6:27 am
If you have copies of the master files, shut down SQL (it's probably already stopped) and copy the copies of the files over the existing files. You'll lose any logins or other config changes you've made since you took those copies.
DAC is not helpful here, Master can's start and hence SQL can't start, hence there's no service to connect to, even with DAC.
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 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply