Cannot delete mdf file

Scenario: You have an environment which has backup scheduled as daily full and hourly log backup. Cool, its quite good in terms of most effective recovery and possible data loss would be less than on hour. So how do you recover data for remaining 30 minutes?

Also the every environment should need a proper backup configuration to restore to latest point for better data recovery. Note: If you stop and start the sql services you can get error message from sql error log as well.

Read more about tail log backup here. Like Liked by 1 person. Like Like. I have tried using process explorer and can't figure out how to use it to find what is using the db.

Searching for a db name doesn't result in anything. Even searching for functioning db's doesn't result in anything. I have tried searching and drag and drop on the bulls eye icon. Strange thing is if I create a backup that database is in the selection list for databases. Show 5 more comments. Active Oldest Votes. Try to set the database returned by the query in sys. But if you want to delete the file, you could also just try to drop the database Drop database [YourDB];.

Improve this answer. Dominique Boucher Dominique Boucher 2, 6 6 silver badges 19 19 bronze badges. Ask a question.

Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Visual C. Sign in to vote. Wednesday, May 8, AM. Thanks to everyone for their reponses. Tuesday, May 14, AM. To run SQL Server with administrator you need to:. It is an adept software used to analyze the objects of MDF file and preview the following database object. If users want to attach or open MDF File from any other location of the system then, users need to provide security permission to the folder in which files are stored.

Thursday, January 13,