.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

How to turn off warning messages during php execution?

1021

What is the function of sql server agent windows service?

1068

What is the difference between system objects and user objects?

1141

How to rebuild all indexes on a single table?

1040

What is enhanced database mirroring in sql server 2008?

954

Do you know hot add cpu in sql server 2008?

939

Can we hide the definition of a stored procedure from a use?

1200

What are the 2 types of classifications of constraints in the sql server?

1101

What is the command dbcc checkdb used for?

995

What are points to remember while using the fillfactor argument?

952

What is difference between aggregate and analytic function?

906

How many types of local tables are there in sql server?

915

What is SubQuery in SQL Server 2008

1006

Can you explain what is sql server english query?

980

How check triggers in sql server?

966