SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error

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.

Fix/WorkAround/Solution:

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 (https://blog.sqlauthority.com)

Solarwinds
, , ,
Previous Post
SQL SERVER – T-SQL Script to Attach and Detach Database
Next Post
SQL SERVER – 2005 – No Backup Support For Named Pipes

Related Posts

Leave a Reply

Menu