If you try and attach a mdf file that does not have an associated ldf file in SQL Server Management Studio, SSMS will throw an error. The simplest way around it is – click on the ldf file location in the dialog and click Remove. SSMS will then attach the MDF file and create the associated LDF file for you.
Yesterday I was in unpleasant difficult situation. All my sql .mdf files were corrupted. And I used the the Google and saw there - best .mdf file repair utility. The utility solved my problem for seconds and free of charge as I bore in mind.
ReplyDelete