How do I delete MDF and LDF files?

How do I delete MDF files?

Expand Databases, right-click the database from which to delete the file, and then click Properties. Select the Files page. In the Database files grid, select the file to delete and then click Remove. Click OK.

How do I delete MDF and LDF files in SQL server?

These files can be deleted manually by using Windows Explorer. Show activity on this post. Drop the database is just to bring it offline.

Can I delete log LDF files?

You should not delete any of the database files since it can severely damage your database! If you run out of disk space you might want to split your database in multiple parts.

Can I delete SQL transaction log files?

Note: The active transaction log file cannot be removed. Previously, we saw that once the primary log file becomes full, SQL Server uses the secondary log file. We need to make a secondary transaction log empty, so we can remove it.