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