I/o Error 38reached The End Of The File
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site https://support.microsoft.com/en-us/kb/313702 for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error attaching database after deleting http://dba.stackexchange.com/questions/13908/error-attaching-database-after-deleting-ndf-file NDF file up vote 2 down vote favorite I have deleted .ndf file by mistake from a SQL Server 2008 database. While trying to attach a previous copy, SSMS raises this error: Attach database failed for Server 'MDSWIN34'. (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\template.ndf'. 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. (Microsoft SQL Server, Error: 823) What is the reason for this? Have I lost all of my data? sql-server-2008 dbcc share|improve this question edited
offset 0x000000dfbce000 in file 'D:\FocalPoint\Databases\001_001\pdi_stage_001_001.mdf'.. It occured during cube and dimision updates on analytical services. The D drive resides on a SAN. Our http://helpemergency.blogspot.com/2012/03/io-error-38reached-end-of-file.html network administrator is saying there are no drive issues. Everything I have read on Error 823 is hardware related. Any suggestions. Thanks.Take a look at http://support.microsoft.com/kb/313702Linchi"brymer28303" wrote:> We received this error last night:> Error: 823, Severity: 24, State: 2> I/O error 38(Reached the end of the file.) detected during read at offset> 0x000000dfbce000 in file> 'D:\FocalPoint\Databases\001_001\pdi_stage_001_001.mdf'..> It occured during cube and dimision updates on analytical i/o error services. The D> drive resides on a SAN. Our network administrator is saying there are no> drive issues. Everything I have read on Error 823 is hardware related.> Any suggestions. Thanks.> Posted by perplexingmqwo at 1:58 AM Email This BlogThis! Share to Twitter Share to Facebook Labels: database, detected, error, file, microsoft, mysql, offset, oracle, received, server, severity, sql, state No comments: Post a Comment i/o error 38reached Newer Post Older Post Home Subscribe to: Post Comments (Atom) help emergency Blog Archive ▼ 2012 (482) ▼ March (394) I'd like to get a good book of SQL... Id getting generated differently ID for New record ID Field Reset ID Edition? General MS SQL training? ID Creation/ASP/SQL Server ID Column has backed down ! ID Column has backed down ! ID Column has backed down ! I'd changed the server name, sql server can't star... Id (indentity) is increments on faults. Iconsistent DB Iconsistent DB Iconsistent DB Icons? Icons used in SQL 2005 Icons in enterprise manager 7 Icons for Custom Tasks won't show up. Icons for Custom Tasks won't show up. Icon Tray SQL Icon not displayed correctly for custom component Icon missing Icon missing Icon in System Tray Flashing Red Icon in System Tray Flashing Red ICommandText::Execute() causes mem leaks? ICF, SQL SERVER 2000 and Windows 2003 IBMDASQL OLEDB linked server "access denied" using... IBMDASQL OLEDB linked server "access denied" using... IBM Universe Database IBM SDK IBM SDK IBM Informix Ole Db Provider IBM Informix Ole Db Provider IBM DB2 UDB for iSeries .NET data provider IBM DB2 as Da