Posted by Erland Sommarskog on 10/18/07 21:15

DA Morgan (damorgan@psoug.org) writes:
> Fix the problem. Half the time, with Windows, the correct solution to a
> problem is a reboot. This is one of those times.

Maybe. If SQL Server is not set to auto-start it will work, in so far that
you will get rid of the files. But since the databases will still be in
master.sys.databases, it's not a very pretty solution. And in most cases,
SQL Server is set to auto-start, in which case rebooting the box is not
going to help at all.

But your answer is interesting. I take it that to get rid of database
files with Oracle, DROP DATABASE is not the way to go, or at least it is
not sufficient. But do you really have to reboot to get Oracle to let go
of the files?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Run SQL script on Instance Startup
• Prev in forum: Re: Run SQL script on Instance Startup
• Thread view: Re: delete database file on server -> sharing violation

[Reply to this message]