Important Note: Before proceeding to the following steps, we strongly advise taking your database backup without fail. You need to proceed at your own risk.
We will use the DBCC (database console commands) commands in the SQL Server Management Studio to repair the corrupt MDF files of the SQL database.
There are many DBCC commands to check and repair the SQL database, like DBCC CHECKDB, DBCC DBREPAIR.
To fix the corrupt MDF files in the database, follow the steps below.
Step 1: Open the SQL Server Management Studio.
Step 2: Now, click on New query.
Step 3: Write the script below in the query and execute it.
EXEC sp_resetstatus [YourDatabase]; ALTER DATABASE [YourDatabase] SET EMERGENCY DBCC CHECKDB ([YourDatabase], REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC DATABASE ([YourDatabase], REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE [YourDatabase] SET MULTI_USER
Replace the YourDatabase with your actual database name. Once you execute it, there should be no more corrupt MDF files in your database.
