Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1154
  • Last Modified:

SQL 2000 latch page errors urgent

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
Netstore
Asked:
Netstore
  • 3
1 Solution
 
imran_fastCommented:
Run this on your database and check the result

DBCC CHECKDB
GO
0
 
imran_fastCommented:
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
 
NetstoreAuthor Commented:
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
 
imran_fastCommented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now