Forum Discussion

komail_2811's avatar
komail_2811
Copper Contributor
Dec 08, 2023

How To Attach MDF File Without Log File

Hi, I have one MDF file without LDF file when attach this file to sql i have this error , how to solve this problem ? in first step :    USE master GO EXEC sys.sp_attach_single_file_db @dbnam...
olafhelper's avatar
olafhelper
Bronze Contributor
Dec 18, 2023

 

komail_2811 wrote:

Hi,
I have one MDF file without LDF file

when attach this file to sql i have this error , how to solve this problem ?

Error : The FOR ATTACH option requires that at least the primary file be specified.

komail_2811 , the error message is not complaining about a missing LOG file, it says the file isn't a valid primary database file.

  • komail_2811's avatar
    komail_2811
    Copper Contributor
    Jan 09, 2024
    Thanks
    but How to solve this problem ?
    • olafhelper's avatar
      olafhelper
      Bronze Contributor
      Jan 09, 2024
      To solve it you have to get the right&all database files.

Resources