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

Last Post

RSS

khaibl

(@khaibl)

Member Admin

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’

Quote

Topic starter Posted : 31/08/2020 10:05 am

Forum Statistics

31 Forums

320 Topics

443 Posts

3 Online

24 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed