I recieve an error message "Create Database failed." How do I delete other files assoicated with previously deleted database?

I had previously dropped a database thinking I wasn't going to use the database name. Now, I decided to create a database using the same previous name. In Object Explorer, I right clicked on the folder Database and selected the New Database function and then, typed the name of the Database. The message says the file already exists. What else do I need to do to ensure dropping a database encompassses every other relative file is deleted with it (example the log files).? Doesn't "Drop Database" cover deletion of all relative files? Did my administrator only allow certain privileges? Please advise.

Thank you for your assistance.
5532Asked:
Who is Participating?
 
Chris MangusDatabase AdministratorCommented:
Yes, it should have deleted them, depending on the status of the database when you issued the DROP.

To delete the physical files you will need to delete L:\SQL\_Logs\MSSQL\Data\Customers_log.ldf and L:\SQL\_Logs\MSSQL\Data\Customers.mdf from your server.
0
 
Chris MangusDatabase AdministratorCommented:
DROP DATABASE should delete the physical files too unless the database was offline when you issued the DROP.
0
 
5532Author Commented:
Should I run it again?

The complete error message reads:

"CREATE DATABASE failed. Some file names listed could not be created. Check related error.
Cannot create file 'L:\SQL\_Logs\MSSQL\Data\Customers_log.ldf' because it already exists.
Change the file path or the file name, and retry the operation. (Microsoft SQL Server, Error: 1802)"
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
5532Author Commented:
I executed "DROP DATABASE Customer" again. I recieved this message:

"Cannot drop the database 'BusinessServices', because it does not exist or you do not have permission."

I'm thinking I don't have the permission but Is there a way I can tell I don't have the proper permissions to drop a database?

0
 
5532Author Commented:
Sorry, I meant 'Cannot drop the database Customer...." I've got a lot on my mind. Thanks
0
 
Chris MangusDatabase AdministratorCommented:
When you issued the first DROP DATABASE you should have been denied if you didn't have permission.

I would simply delete the old physical files, unless you need them, and then just create your new database.

Alternatively, you could attach the existing files and then try the DROP DATABASE again.
0
 
5532Author Commented:
How do I delete the physical files? Shouldn't DROP DATABASE take care of these files as previously mentioned in prior post?
0
 
5532Author Commented:
Sounds like I have to go to the location L: and delete the physical files from this location. Is there a way I can at least view the location with these files from within Management Studio?
0
 
Chris MangusDatabase AdministratorCommented:
Yes, you can query:

Exec master.dbo.xp_cmdshell 'Dir L:\SQL\_Logs\MSSQL\Data'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.