This is important because repairing a SQL db and running a DBCC CHECKDB command are two separate operations. You can use it to perform database repair “without the possibility of data loss.”īefore you run the ‘DBCC CHECKDB REPAIR_REBUILD’ command, make sure to put the database in a SINGLE_USER mode by executing the below command: ALTER DATABASE your_dbname SET SINGLE_USER The REPAIR_REBUILD command helps rebuild corrupt pages or repair missing rows in non-clustered indexes. How to Fix Corrupt SQL Database Using ‘DBCC CHECKDB With REPAIR_REBUILD’? The following section will discuss how to fix the database corruption errors when ‘REPAIR_REBUILD’ is recommended as the minimum repair level to resolve all errors reported by DBCC CHECKDB. If there is no good backup, you can fix the errors by running the DBCC CHECKDB command with a repair option needed to fix specific errors. If hardware or software issues are not detected, the best solution to fix corruption is to restore the database from the most recent backup. Virus or Malware Attack: The SQL database files can get corrupted due to a virus or malware attack, turning the files inaccessible.Bugs in the SQL Software: If you can’t find any issue with the underlying hardware, check for software bugs, as Microsoft is known to cause index corruption or data loss while running an online index rebuild in SQL Server 2012/2014.Or else, contact your hardware vendor or device manufacturer to resolve the underlying hardware issues. If the consistency errors are caused due to hardware problems, ensure that the configuration of the hardware device meets with the Microsoft SQL Server Database Engine Input/Output requirements.

Faulty Hardware: Check for defects in disk controllers, device drivers, or other hardware components.Possible Reasons Behind SQL Database Corruptionįollowing are the most common reasons leading to SQL Server database corruption: If DBCC CHECKDB reports consistency errors, you must identify the root cause behind database corruption to find the best possible solution to fix the errors. These checks may fail due to corruption in the database. What If ‘DBCC CHECKDB REPAIR_REBUILD’ Fails?Īs database administrators, you must be running the DBCC CHECKDB command to check your SQL database’s physical and logical consistency.How to Fix Corrupt SQL Database Using ‘DBCC CHECKDB With REPAIR_REBUILD’?.Possible Reasons Behind SQL Database Corruption.

Rebuild master database sql server 2016