Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Har drive fail
Message
From
28/03/2000 20:44:04
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Title:
Har drive fail
Miscellaneous
Thread ID:
00351836
Message ID:
00351836
Views:
45
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
Map
View

Click here to load this message in the networking platform