Failed Assertion

Could you please help me out if you know how to resolve this error:
SQL Server Assertion: File: <diskio.c>, line=670
Failed Assertion = 'filepos + cBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
On Fri, 1 Jun 2007 13:11:01 -0700, sam wrote:

>Could you please help me out if you know how to resolve this error:
>SQL Server Assertion: File: <diskio.c>, line=670
>Failed Assertion = 'filepos + cBytes <= (DWORDLONG) m_size << PAGESIZEBITS'.
Hi Sam,
A failed assertion is on most cases an indication of a bug. It could
also be related to some inconsistency on your DB.
Steps to take:
1. Run CHECKDB on your databases.
2. Upgrade to latest service pack.
3. If problem persists, open a support case with Microsoft.
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
|||Hi Hugo,
Thanks a lot for your quick respond on this matter. Yes, Planning to run
dbcc checkdb on affected database. Also, suggested team to upgrade SQL Server
2000 to SP4, currently it is SP3 with Hotfix 818.
Thanks,
Sam
"Hugo Kornelis" wrote:

> On Fri, 1 Jun 2007 13:11:01 -0700, sam wrote:
>
> Hi Sam,
> A failed assertion is on most cases an indication of a bug. It could
> also be related to some inconsistency on your DB.
> Steps to take:
> 1. Run CHECKDB on your databases.
> 2. Upgrade to latest service pack.
> 3. If problem persists, open a support case with Microsoft.
> --
> Hugo Kornelis, SQL Server MVP
> My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
>