Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Logical consistency error Expand / Collapse
Posted Friday, January 4, 2013 5:12 AM



Group: General Forum Members
Last Login: 2 days ago @ 5:18 AM
Points: 45,619, Visits: 44,147
devanandiiway (1/4/2013)
Do you mean that I need to move all the mdf from that drive?

Unless you are happy that the databases on there may potentially become corrupted, yes. That's like asking if you should keep critical data on a drive that's giving known problems. Personally I wouldn't, but if you don't care if that critical data is lost, then keep it there.

Is there anyway I can repair the hardware? Since it is occuring often.

Maybe. Depends what's wrong with it. You need to check the IO subsystem (everything from the drivers to the disks) and look for problems.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1402816
Posted Sunday, January 13, 2013 1:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 10, 2013 3:10 AM
Points: 54, Visits: 255
I will move all my mdf files to other drive and let you know.

Post #1406455
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse