Follow the below methods: Method 1-Rebuild the corrupt Log file Step 1 - Locate the log file. You can execute the following query to know the location of data file and log file of each database.