Hi

As far as I know when we drop some database, database files (.mdf and.ldf) also get deleted from the location. right???

But yesterday I was trying to restore a large database and I thought I will drop the existing database first and then I will restore it . so I dropped the database and tried to restore the database to the same location but it gave me the error that data and log files are already existing on the location. So i deleted the old files and then restored and it worked fine!!!

Could u think of any possible reason why the data and log files were not deleted automatically when I dropped the database???

Thanks!!