Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 313702 - Last Review: February 22, 2007 - Revision: 4.3
The SQL Server service may fail to start with I/O error message 38 in the tempdb database
This article was previously published under Q313702
On This Page
SYMPTOMS
The SQL Server service may fail to start and you may receive the following error messages in the SQL Server error logs or in the event viewer application log of the computer:
spid5 Clearing tempdb database.
spid5 Encountered an unexpected error while checking the sector size for file 'DRIVE:\SQLFOLDER\DATA\TEMPDB.MDF'. Check the SQL Server error log for more information.
spid5 CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.
spid5 Error: 823, Severity: 24, State: 6
spid5 I/O error 38(Reached the end of the file.) detected during read at offset 0000000000000000 in file 'DRIVE:\SQLFOLDER\DATA\TEMPDB.MDF'.
spid5 WARNING: problem activating all tempdb files. See previous errors. Restart server with -f to correct the situation.
: This article applies only to the
tempdb database.
CAUSE
- Hardware problems.
-or-
- Permissions problems.
RESOLUTION
To resolve this problem, use any of these methods:
- Check the accessibility and condition of the device in question.
- Run hardware diagnostics and correct problems, if possible.
- Make sure that the disk drive (for example, C:\, D:\) where tempdb is located has sufficient NTFS permissions for the accounts that need access (that is, the account with which you start the SQL Server services, the system account, the Administrators group; all of these account must have Full Control).
REFERENCES
For additional information, click the article numbers below
to view the articles in the Microsoft Knowledge Base:
148437Â
(http://kbalertz.com/Feedback.aspx?kbNumber=148437/EN-US/
)
Default NTFS Permissions in Windows NT
244600Â
(http://kbalertz.com/Feedback.aspx?kbNumber=244600/EN-US/
)
Default NTFS Permissions in Windows 2000
266118Â
(http://kbalertz.com/Feedback.aspx?kbNumber=266118/EN-US/
)
How to Restore the Default NTFS Permissions for Windows 2000
120929Â
(http://kbalertz.com/Feedback.aspx?kbNumber=120929/EN-US/
)
How the System Account is Used in Windows
SQL Server 2000 Books Online; topic: "Error 823"
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Express Edition
- Microsoft SQL Server 2005 Workgroup Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please