SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 error while deleting .mdf File
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

arorarahul.0688
Posting Yak Master

India
125 Posts

Posted - 04/15/2008 :  07:08:24  Show Profile  Reply with Quote
can some one please help me to delete a File with extension .mdf, as its continously giving error that file can't be deleted its being used by any other program or user.

Rahul Arora
07 Batch
NCCE Israna,


######################
IMPOSSIBLE = I+M+POSSIBLE

RickD
Slow But Sure Yak Herding Master

United Kingdom
3608 Posts

Posted - 04/15/2008 :  07:11:14  Show Profile  Reply with Quote
Why are you trying to delete a database from file manager in the first place?

If you really want to get rid of the database, drop it first.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30207 Posts

Posted - 04/15/2008 :  07:11:53  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You have to stop the SQL Server service that the file belongs to, first.


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 04/15/2008 :  09:32:37  Show Profile  Visit jezemine's Homepage  Reply with Quote
I hope the file is not master.mdf?


elsasoft.org
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 04/15/2008 :  11:15:23  Show Profile  Reply with Quote
I'd make sure you had a backup before attempting to do what your planning on doing. BUT, that's just me!

Terry
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11750 Posts

Posted - 04/15/2008 :  13:25:14  Show Profile  Visit spirit1's Homepage  Reply with Quote
format c: works great!


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

Edited by - spirit1 on 04/15/2008 13:25:30
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36834 Posts

Posted - 04/15/2008 :  13:41:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
This is just priceless.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 04/15/2008 :  15:44:06  Show Profile  Reply with Quote
Couldn't agree more Tara. Great response spirit1!! You know, one of these fine OPs is actually going to use a suggestion like that someday and wonder what exactly they did wrong. "I was simply following your advice...and now I can't access my data. Can you help?"

Terry
Go to Top of Page

Haywood
Posting Yak Master

USA
221 Posts

Posted - 04/15/2008 :  16:40:38  Show Profile  Reply with Quote
<90°-OT>

I used to work with a guy at an ISP who would get people to format thier boot drives, because we (tech suppt.) had spent enough time already trying to get them connected and the issue had to be with the o/s.

It'd never fail, that, after he gave instructions on how to format the boot drive, they would call up and not have install media or something-other that prevented them from re-installing the o/s - usually to the sound of us laughing like hyenas.

His response was "Bring in the machine, and for $40, we'll re-install the o/s and make sure that it connects to the internet when you leave". We made more money at $40/pop than we did on $20/month dialup accounts....

Some days, I really miss that job. :)

</OT>
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000