devanandiiway (1/3/2013)
The problem is the good backup of this database got expired.
Then you have a serious problem, because there's no way you can repair this error. You need to restore a clean backup here.
When you say move the DB to different disk? I have nearly 9 DB's data files on the same drive.Do I need to move all the 9 DB's data file to other drive??
Well that or risk the others becoming corrupted
Even other db's mdf files stay in this drive healthy?? Why this is getting corrupted?
As I said, IO subsystem problems of some form. 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