Stop SSMS Service 2. Navigate to the location where your MDF and LDF files are located. 3. Delete both and restart the SQL Server services. 4. Open SSMS and expand the database folder. You can also see that the database is in a pending state. 5. Right click on the database and delete it.