General information
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only