Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Har drive fail
Message
De
28/03/2000 20:44:04
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Recouvrement
Titre:
Har drive fail
Divers
Thread ID:
00351836
Message ID:
00351836
Vues:
47
Hi,

i have 4 server they all are connected through replication.
yesterday one of my production server's hard drive failed. I configured my database. but now in my event log i got an following error
Error:823,severity:24,State:1 I/O error (bad page ID) detected during read of BUF pointer = 0x11dc09c0, page ptr = 0x2063e000, pageid =
= (0x1:0x17b20),dbid = 8, status = x801, File :\mssql\data\ors_db.mdf.

when i ran dbcc checkdb i got following error

Server: Msg 8998, Level 16, State 1, Line 1
Page corruptions on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 8 pages from (1:0) to (1:102400). See other errors for cause.
Server: Msg 8909, Level 16, State 1, Line 1
Table Corrupt: Object ID 0, index ID 0, page ID (1:97056). The PageId in the page header = (0:0).
DBCC results for 'ors'.
CHECKDB found 1 allocation errors and 1 consistency errors not associated with any single object.

right now my replication is fine.

if i will run checkdb with repair data then i have to stop my subscription/replication. is there any other way to get rid of this error.

Thanx
...ashish
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform