Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
robertnzana
Starting Member
42 Posts |
 Posted - 2008-06-02 : 18:58:50
|
| when i try to delete my mdf/ldf files I get the message that "it is being used by another person or program."sql server enterprise manager is closed.i assume it's probably the resident mssql server process. is there anyway to delete the files without stopping this process (because other websites are using db's on this server)?thanks! |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-06-02 : 19:28:01
|
| You have to drop the database that those files are for.Be sure that is what you want; when you drop a database, it is gone. It is a good idea to make a backup of the database before you drop it, just in case.CODO ERGO SUM |
 |
|
|
|
|
|
cannot delete mdf/ldf files