.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

What are .mdf files?

Posted By: softraj     Posted Date: May 12, 2010    Points:2   Category :Sql Server
What are .mdf files? What is the use of .mdf files?

Author: Venkat             
Posted Date: May 12, 2010     Points: 5   


.MDF file are used by sql server to stored data. When you create a database it will create 2 more file which reside in the root folder of the sql server.

1 .mdf (Master Data File)
2 .ldf

MDF stored data and ldf stores the log

Mark As Answer if this solve your problem
Warm Regards,
Author: BangaruBabuPureti             
Posted Date: May 13, 2010     Points: 5   

By Seeing This Question I Thought That Ur Beginner

Let Me Explain Step By Step

1. MDF Stands FOR Microsoft Database File

2. It is a Flat File Like Microsoft Databse Access(mdb)

3. In Mdf File Ur Able To Store Your Data In A Relational Manner

4. Able To Create Stored Procedures Triggers,indexes and all

5. Easy to Carry from One Place to Another For Deployment

I Hope This Exposure Will Help full

Go For This Link Even For More Clarity

BangaruBabu Pureti

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend