Want to work with us? We're on the lookout for digital experts.

We're hiring

SQL Server 2012 - File is open in another program

Web Bureau

02 August 2013 by Web Bureau

Ok had an issue when restoring a backup and decided i needed to delete the database. Unfortunately the file system wouldnt allow this.  The reference to the SQL .ldf and .mdf were left in the "Data" folder but within Management Studio the DB was gone.

To solve this i needed to stop and start SQL on the server and then tried to delete the .ldf and .mdf through the file system.

All worked a treat




Grow your businessStart a project with us today.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.