Solved

SQL 2000 latch page errors urgent

Posted on 2006-11-21
4
1,129 Views
Last Modified: 2007-12-19
Hi This is canny urgent:

On last nights integrity check I have the following errors:

Msg 8966, Sev 16: Could not read and latch page (1:89000) with latch type UP. 菴륺 failed. [SQLSTATE 42000]
Msg 8966, Sev 16: Could not read and latch page (1:89001) with latch type UP. 菴륺 failed. [SQLSTATE 42000]
Msg 8966, Sev 16: Could not read and latch page (1:89002) with latch type UP. 菴륺 failed. [SQLSTATE 42000]
Msg 8966, Sev 16: Could not read and latch page (1:89003) with latch type UP. 菴륺 failed. [SQLSTATE 42000]
Msg 8966, Sev 16: Could not read and latch page (1:89004) with latch type UP. 菴륺 failed. [SQLSTATE 42000]
Msg 8966, Sev 16: Could not read and latch page (1:89005) with latch type UP. 菴륺 failed. [SQLSTATE 42000]
Msg 8966, Sev 16: Could not read and latch page (1:89006) with latch type UP. 菴륺 failed. [SQLSTATE 42000]
Msg 8966, Sev 16: Could not read and latch page (1:89007) with latch type UP. 菴륺 failed. [SQLSTATE 42000]

I also received the following warnings around the same time:


DESCRIPTION:      Error: 823, Severity: 24, State: 2
I/O error 1450(error not found) detected during read at offset 0x000000269bc000 in file 'D:\MSSQL\Data\agressodata5.ndf'.

This is worrying me ever so slightly........running a dbcc checkdb again shows all is well as though this is an intermittent error? I am worried that there may be corruption in my ndf file, is there any way to check this?

Additionally does anyone have any idea's what is causing this?
0
Comment
Question by:Netstore
  • 3
4 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 17986914
Run this on your database and check the result

DBCC CHECKDB
GO
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 17986927
sorry i didn't notice you ran checkdb
next step

Checks the consistency of disk space allocation structures for a specified database.
DBCC CHECKALLOC ('YourDbName',REPAIR_FAST )
GO

REPAIR_ALLOW_DATA_LOSS
Performs all repairs done by REPAIR_REBUILD and includes allocation and deallocation of rows and pages for correcting allocation errors, structural row or page errors, and deletion of corrupted text objects. These repairs can result in some data loss. The repair can be done under a user transaction to allow the user to roll back the changes made. If repairs are rolled back, the database will still contain errors and should be restored from a backup. If a repair for an error has been skipped due to the provided repair level, any repairs that depend on the repair are also skipped. After repairs are completed, back up the database.
REPAIR_FAST
Performs minor, nontime-consuming repair actions such as repairing extra keys in nonclustered indexes. These repairs can be done quickly and without risk of data loss.
REPAIR_REBUILD
Performs all repairs done by REPAIR_FAST and includes time-consuming repairs such as rebuilding indexes. These repairs can be done without risk of data loss.
0
 
LVL 5

Author Comment

by:Netstore
ID: 17986964
I've ran another checkdb and no errors are returned ????????

However I ran a dbcc showcontig - (just to check my indexes) and get loads of :

Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (6:32018) with latch type SH. 1450(error not found) failed.
Server: Msg 8966, Level 16, State 1, Line 1

Is there any risk associated with the checkalloc command doing repairs on the fly?
Do I need to do it when the system is quiet? i.e. no users on. I take it I should be taking a backup before running any of this.

Any help greatly appreciated?
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 17987016
You need to rebuild index either you can rebuilt index using
DBCC DBREINDEX on individual table or

>>I take it I should be taking a backup before running any of this.
It will be good but there won't be any problem

run this
DBCC CHECKALLOC ('YourDbName',REPAIR_REBUILD  )
GO

It will take time as it will rebuild indexes.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL: Episode III - Revenge of The Dude 24 53
Query Help - MSSQL - Averages 5 27
SQL Error - Query 6 26
SQL Server Error 21 8 25
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question