Need help with SQL Server 2005 converted database and error.

[sonname]

I recently detached a SQL Server 2000 database installed on a Windows Server 2003 SP1 and brought it over to a SQL Server 2005 running on Windows Server 2003 SP1. I have a web application that uploads images. At some times the upload will hang. In the application log, I see many errors of the following.

The Database ID 5, Page(1:3487), slot 46 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.

Any ideas what this error message means?

Thanks in advance.

 

[ptheriault]

I would start by running DBCC CHECKDB. See if it reports any errors.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

What does it say when you run dbcc checkdb or dbcc checktable?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com