SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error
This is most annoying error. I have only faced this error twice so far. I solved this error restoring the database back up. Read here for additional help on SQL Backup And Restore. This error is occurs when database is in state when it can not be heal itself, i.e. corrupted metadata or corrupted important system database files.
My prefered order to fix the problem.
1) Restored database from backup.
2) Run DBCC with repair option, which will not bring much favorable answer.
3) Check if there is any hard ware problem with hard disk or Raid control.
Reference : Pinal Dave (http://blog.SQLAuthority.com)