.mdf is extention of primary file, .ndf is extention of secondary file, .

What are mdf,ndf,ldf files and how to see the data in those
files?

Question Posted / visala

Answer Posted / visala

.mdf is extention of primary file,
.ndf is extention of secondary file,
.ldf is extention of log file,

sp_helpfile

Is This Answer Correct ?

116 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Difference between connected and disconnected database in .net with sql server?

1094

How do I install sql server?

886

What is buffer cash and log cache in sql server?

1122

How efficient you are in oracle and SQL server?

1150

What is data file in computer?

942

What are the types of lock supported by ?

1044

What is partition, how will you implement it? : sql server analysis services, ssas

1046

What is the difference between index seek vs. Index scan?

1023

last function used in MS Access to convert sql what function will use in sql

2070

Where cross join is used?

958

What is change data capture (cdc) in sql server 2008?

1024

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1076

What is a trace frag?

1083

What the class forname () does?

1058

What are dml (data manipulation language) statements in ms sql server?

983