March 16, 2010 at 3:41 am
One of the sql server has kicked off " Fatal Error 823..." all of a sudden. I am lost the disk that has tempdb and userdatabase but ofcourse i have database backups.
Does it main Disk failed compeltely and what resolutions would work in this case.
Here is the message is see in system log
Event Type:Error
Event Source:LDM
Event Category:None
Event ID:1500
Date:3/14/2010
Time:6:10:11 PM
User:N/A
Computer:OBBEAVER23
Description:
Disk group ObebavertempDg0: Reimport of disk group failed:
Disk group has no valid configuration copies
Thanks
March 16, 2010 at 9:38 am
So a disk failure is a Windows/hardware event, not a SQL Server one. Can you see and access the disk from Windows? Once that is working, SQL Server should pick it up.
March 16, 2010 at 1:52 pm
823 is a hard IO error. SQL requested a read of the disk and the OS returned an error.
Clustered?
Is the disk available through windows?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply