mdf: When You Create Database .this Primary file ndf: This is Sceondry Fil

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

Question Posted / 1 aug @008

Answer Posted / 1 aug @008

mdf: When You Create Database .this Primary file
ndf: This is Sceondry File
ldf: Lof Files

Is This Answer Correct ?

42 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is difference between views and tables?

1010

What is forward - only cursors / read only cursor?

1089

Explain timestamp datatype?

969

What is replication and database mirroring?

1047

what happens on checkpoint? : Sql server database administration

1097

List all types of constraints in sql server?

1032

What is the difference between ‘having’ clause and a ‘where’ clause?

1037

What does the not null constraint do?

1086

How to make a column nullable?

1109

Which are new data types introduced in sql server 2008?

1049

what is blocking? : Sql server database administration

1040

How extra digits are handled with numeric data type literals?

966

What are the types of user defined functions in sql server?

1049

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

1166

Can an entity have two primary keys?

979