Delete *.mdf and *.ldf files 1

[AgentM]

How can I delete the *.mdf and *.ldf files?

I ran a db creation script, which failed, but it managed to create the *.mdf and *.ldf files with huge space earmarked.
So now there is no database,but I am stuck with this huge space occupied by these files.

any help appreciated.

 

[mrdenny]

If you can't delete the files that's becuase SQL thinks that it's still using them.

Check the master.dbo.sysaltfiles and see if they are listed.

If they are then the database was created and will need to be dropped before you can delete them.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[AgentM]

Hi,
I was trying to create a copy of only the structure of a database, using "generate Sql script". Looks like the script worked fine. But I don't see the Database what am I missing?

Please let me know.
thank you.

 

[AgentM]

Got it