Attach file mdf SQL không cần file log (LDF)

khaibl — Mon, 31 Aug 2020 10:05:25 +0000

Step to delete LDF file of database:

1. Detach the database using script.

sp_detach_db ‘Your-Database-Name’

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’

Attach file mdf SQL không cần file log (LDF) - Ebook về lập trình