Attach file mdf SQL không cần file log (LDF)
Step to delete LDF file of database:
1. Detach the database using script.
2. Delete the LDF file from disk.
3. Execute following script to recreate the LDF file and attach database
EXEC sp_attach_single_file_db @dbname = ‘Your-DB-Name’ , @physname = ‘Existing-MDF-Full-Path’