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 (http://blog.SQLAuthority.com)

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s