Monday, March 12, 2012

Failed Assertion

We're getting the following on a Windows 2003 Server, running SQL 2000 SP3a.
17066:
SQL Server Assertion: File: <diskio.c>, line=670
Failed Assertion = 'filepos + CBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
Any ideas?
Jeremy
Well I think by Failed Assertion means it failed some runtime check. Theres
no way to really know whats causing this error in your specific instance but
its probably some kind of database information inconsistency. Type DBCC
CHECKDB and see what it says. Your database probably isnt normalized well
enough.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200601/1

No comments:

Post a Comment