sql server .mdf file problme-please help

Question

1.00/5 (1 vote)

See more:

Hello. I am screwed. I have a website project and in that, i have one database file. That is my main database for the website. So, the .mdf file I accidently opened with notepad. How can I remove this? That is make it as it was before. PLease help.

Posted 22-May-13 10:00am

JL_Coder

Add a Solution

Comments

Zoltán Zörgő 22-May-13 16:13pm

You can not "remove" editing of a file. You opened the mdf file with notepad, and you also saved it? I suppose it was your only copy. Sorry to say, but you deserve it.

JL_Coder 22-May-13 16:19pm

No. it was not my only copy. but what happened now is, in my whole laptop it is opening with the notepad. I thought to just try, didn't know it ll be like this. OK, I am fool. But let me know, will it affect anything?

JL_Coder 22-May-13 16:22pm

can I do something like, I remove "virtual.mdf" (my file's name) and my friend has the same project. I copy it from his laptop and paste it. Will it be normal or It will again pop up with notepad symbol?

Zoltán Zörgő 22-May-13 16:26pm

Oh, you associated mdf with notepad? That's an other thing. Just use right click re-associate with what you like. But actually it should not matter, you don't open a database file with an editor, you attach it to an sql server instance, and access it via that one.

JL_Coder 22-May-13 16:32pm

yes my friend, I associated it with notepad, that too in little bit hurry. Humans do mistakes when they are in hurry. I know I don't open it, I did it for some other matter. If you see, in .mdf files when you right click and see properties, in open with: there is written "unknown application". Before it was this. When I associated it with notepad, now it is showing, "notepad" and symbol of notepad comes with it. I want to make it as it was before, that is symbol of a yellowish server and "unknown application" written in open with: tag. How can I do this? OKay, even if i cant do this, let me know, will it affect any operations related database? What if I want to upload that "virtual.mdf" file on internet server while hosting my website?

Zoltán Zörgő 22-May-13 17:11pm

You could remove it (see: http://superuser.com/questions/51503/delete-windows-file-association-using-reg-file). But I assure you, it won't affect anything at all.

JL_Coder 22-May-13 17:30pm

ok thanks...:)

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vipin kumar.P · Answer 1 · 2013-05-22T19:28:00

Solution 1

Try to open the file with OpenWith option
Select your file and click mouse right button and go for the option OpenWith and select the appropriate program

Posted 22-May-13 19:28pm

Vipin kumar.P