.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

Can one drop a column from a table?

1020

What are different types of database indexes?

1103

What program is used to store the data source file?

962

What is tempdb database? : SQL Server Architecture

1198

Is sql server free?

920

What are the advantages of passing name-value pairs as parameters?

1168

How to enter comments in transact-sql statements?

945

Explain the truncate command?

987

can any body tell me how to know the password of current user in sql server

2073

How adventureworkslt tables are related?

930

What is an indexing technique?

936

What structure can you implement for the database to speed up table reads?

1199

What is difference between rollback immediate and with no_wait during alter database?

1092

Tell me what is sql profiler?

1032

What is repeatable read?

1021