Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

unable to delete, File is open Expand / Collapse
Posted Wednesday, October 2, 2013 4:56 AM


Group: General Forum Members
Last Login: Wednesday, February 24, 2016 9:55 AM
Points: 12, Visits: 49
Hi am delete database but it says:

cannot delete database because the file is open in sql server, I can see the database from:
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
but unable to deleted through right click- delete. plse advise.

Thank you for your time.
Post #1500726
Posted Wednesday, October 2, 2013 5:03 AM

Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, October 11, 2016 4:41 AM
Points: 713, Visits: 3,323
If the database is still attached to the SQL instance then you won't be able to delete it via windows explorer.

You can either delete the database from the SQL Server Management Studio Express or detach the database then delete the data and log files.


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1500727
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse