Error 7105 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Error 7105

Author

Topic

JohnDeere
Posting Yak Master

191 Posts

Posted - 2006-06-16 : 11:33:11

The following error was posted in the sql error log

Error: 7105, Severity: 22, State: 6
Page (1:833858), slot 60 for text, ntext, or image node does not exist..

I ran a Full backup and copied it to a test server.
I ran a checkdb on the test server and it reported no errors.

I am running
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

I have a 2 node 2 instance cluster.
The CPUs are 8 CPU Unisys boxes with 16GB of ram.
We have enabled the AWE settings.
Our storage system is an EMC CX300.

Thanks

Lance Harra

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-06-18 : 13:02:33

Are you running queries using NOLOCK? Or in READUNCOMMITTED isolation level?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

JohnDeere
Posting Yak Master

191 Posts

Posted - 2006-06-19 : 10:22:49

Not that I am aware of but this is a purchased package and I do not have access to all the queries that are inside the application.

Thanks

Lance Harra

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-06-19 : 13:16:52

Hmm - it could be that but we can't be sure. There are no known issues in SP4 that could cause this error.

Has it ever happened before? Are you using any 3rd party disk caching products?

Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)

JohnDeere
Posting Yak Master

191 Posts

Posted - 2006-07-06 : 12:15:11

No, we are not using any 3rd party caching products.
We are using the cache on the cx300.
The problem has only happened the one time.
Hopefully it will not keep happening.

Lance Harra

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources