Sql server log file does not match the primary file

If this is an existing database, the file may be corrupted and should be restored from a backup. It may be from a different database or the log may have been rebuilt previously. Can you please help me how I can resolve this issue and what needs to be done to mitigate?

There is a safety mechanism in the database startup where it checks whether all files below to same database. It is not possible to open and read the files to find out information about MDF files when it is attached. Here is the quick demo of various parameters and the output. I have found this quite powerful and thought was worth a share. As we can see that by using the command we can read the header of the file and get various properties of primary files. This is how I solved my problem.

Improve this answer. Rob Rob Rob, I didn't check in the log file. If you absolutely have to do this, you should version backups. I recommend versioning a script which creates the entire database tables, sprocs, views, etc. Cade Roux Cade Roux This sounds like the data files do not match the structure files of your database.

Georgi Georgi 4, 4 4 gold badges 23 23 silver badges 20 20 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. As I mentioned earlier, we had backups taken of the database and all we needed to do was restore the MSDB database first situation. He holds a Masters of Science degree and numerous database certifications. Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? Try to use automated tool i. See the SQL Server errorlog for details. But after wasting so many hours, still facing same error. Please help. Try to avoid DBCC command, it will not work in the highly corrupt database file. Our organization hard drive crashed due to hardware issue. We have not taken backup. Your email address will not be published. Stellar Data Recovery Blog. Recovers deleted files, photos, videos etc.

Database Recovery. Written By. Priyanka Chauhan. Approved By. Kuljeet Singh.