Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iuseyew
Starting Member
4 Posts |
 Posted - 2007-09-07 : 17:39:46
|
| i believe this is the right thread... i recently had an issue where my xpstar.dll would not register and i read to fix the issue to reapply the SP so i installed SP4 i now am getting this error... please help!2007-09-07 14:24:19.24 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.2007-09-07 14:24:19.24 server SQL Server is starting at priority class 'normal'(4 CPUs detected).2007-09-07 14:24:19.36 server SQL Server configured for thread mode processing.2007-09-07 14:24:19.38 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.2007-09-07 14:24:19.40 server Attempting to initialize Distributed Transaction Coordinator.2007-09-07 14:24:20.44 spid3 Starting up database 'master'.2007-09-07 14:24:20.49 spid3 Error: 823, Severity: 24, State: 5.2007-09-07 14:24:20.49 spid3 ReadFileHdr: Operating system error 38(Reached the end of the file.) encountered.2007-09-07 14:24:20.49 spid3 Error: 5159, Severity: 16, State: 3.2007-09-07 14:24:20.49 spid3 09/07/07 14:24:20 Stack Overflow Dump not possible - Exception c00000fd E at 0x00449CA12007-09-07 14:24:20.49 spid3 Address=449ca1 Exception Code = c00000fd2007-09-07 14:24:20.49 spid3 eax=ba65a0de ebx=00000002 ecx=42ba8740 edx=0bb0a8302007-09-07 14:24:20.49 spid3 esi=00000001 edi=42ba8740 eip=00449ca1 esp=0bb09fc42007-09-07 14:24:20.49 spid3 ebp=0bb0a56c efl=000102122007-09-07 14:24:20.49 spid3 cs=1b ss=23 ds=23 es=23 fs=3b gs=02007-09-07 14:24:20.49 spid3 1: Frame: 0BB0A56C Return Address 00449CA12007-09-07 14:24:20.49 spid3 2: Frame: 0BB0AD88 Return Address 00449E102007-09-07 14:24:20.49 spid3 3: Frame: 0BB0AD9C Return Address 0044A14B2007-09-07 14:24:20.49 spid3 4: Frame: 0BB0ADAC Return Address 0044A17D2007-09-07 14:24:20.49 spid3 5: Frame: 0BB0ADF8 Return Address 0044A19B2007-09-07 14:24:20.49 spid3 6: Frame: 0BB0AE18 Return Address 004CD11C2007-09-07 14:24:20.49 spid3 7: Frame: 0BB0B2A8 Return Address 005ED83E2007-09-07 14:24:20.49 spid3 8: Frame: 0BB0B2FC Return Address 004054732007-09-07 14:24:20.49 spid3 9: Frame: 0BB0B324 Return Address 004493572007-09-07 14:24:20.49 spid3 10: Frame: 0BB0B350 Return Address 004493292007-09-07 14:24:20.49 spid3 11: Frame: 0BB0B378 Return Address 00448EE12007-09-07 14:24:20.49 spid3 12: Frame: 0BB0B3E0 Return Address 0060CFF52007-09-07 14:24:20.49 spid3 13: Frame: 0BB0BC04 Return Address 006D09912007-09-07 14:24:20.49 spid3 14: Frame: 0BB0BC18 Return Address 0044A14B2007-09-07 14:24:20.49 spid3 15: Frame: 0BB0BC28 Return Address 0044A17D2007-09-07 14:24:20.49 spid3 16: Frame: 0BB0BC74 Return Address 0044A19B2007-09-07 14:24:20.49 spid3 17: Frame: 0BB0BC94 Return Address 004CD11C2007-09-07 14:24:20.49 spid3 18: Frame: 0BB0C124 Return Address 005ED83E2007-09-07 14:24:20.49 spid3 19: Frame: 0BB0C178 Return Address 004054732007-09-07 14:24:20.49 spid3 20: Frame: 0BB0C1A0 Return Address 004493572007-09-07 14:24:20.49 spid3 2007-09-07 14:24:20.49 spid3 TotalPhysicalMemory = 2146951168, AvailablePhysicalMemory = 15520972802007-09-07 14:24:20.49 spid3 AvailableVirtualMemory = 376274944, AvailablePagingFile = 3696713728 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-07 : 19:10:21
|
| "2007-09-07 14:24:20.44 spid3 Starting up database 'master'.2007-09-07 14:24:20.49 spid3 Error: 823, Severity: 24, State: 5.2007-09-07 14:24:20.49 spid3 ReadFileHdr: Operating system error 38(Reached the end of the file.) encountered."Its possible that your master database is corrupted, have you got a backup that you could try restoring?Before doing so I recommend that:Stop the SQL ServiceCopy the master.mdf and master.ldf to a safe locationIf the restore fails, or does not improve things, then you could reinstate the current state by stopping SQL Server again and copying-back the saved files.Kristen |
 |
|
|
iuseyew
Starting Member
4 Posts |
Posted - 2007-09-07 : 19:23:24
|
| thank you for the info... i should have said that the reason i am checking the log file and seeing this error is because the "mssqlserver" service will not even start it terminates unexpectedly even when i manually try to start it. I also get an error on the "mssqlServerADhelper" service stating that the system cannot find the specified file. the enterprise manager will not even open the sql snapin as if the update did not complete... however the SP install did complete i rebooted the server and made sure the databases were still there everything looked ok. my most recent backup is missing but i am sure that i have a tape backup from a day or so ago. should i try to reinstall the SP? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-07 : 19:35:24
|
| Any chance you have a copy of the Master database files (MDF + LDF) from when the SQL Service was stopped?(We now take a copy of these periodically for just such an eventuality).Putting those in place (after having preserved the originals, as above) would allow you to get the system upright, and then you could look to restore a "real" backup from before the corruption - which would reinstate anything else that had been added recently - such as users, databases, and so on.Can't guarantee this will work, just thinking out loud. Best to take all precautions you can think of to be able to reverse anything you try as a fix.A fresh install of SQL Server would also give you "workable" master files, but they do need to be identical in terms of folders and so on.Kristen |
|
|
|
iuseyew
Starting Member
4 Posts |
Posted - 2007-09-07 : 19:48:40
|
| i think a reinstall is needed none of the sql apps are functioning... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-07 : 22:58:07
|
| Tried rebuild master db? |
|
|
|
iuseyew
Starting Member
4 Posts |
Posted - 2007-09-10 : 14:38:11
|
quote:
Originally posted by rmiao
Tried rebuild master db?
i am not a sql admin... but i do not think i can do that untill after i have sql functioning properly! i think there may be a raid card issue that caused this SP from applying properly so i need to wait for a local admin to verify first.. its a great time for vacations :\ |
|
|
|
|
|
|
|
|
ReadFileHdr: Operating system error 38(Reached the