Information générale
Forum:
Microsoft SQL Server
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement