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

How to create view in stored procedure sql server?

1017

How to Update from select query in sql server?

1061

Explain transaction server distributed transaction?

980

What is blocking and how would you troubleshoot it? : sql server database administration

1043

Why do we need different type of parameter?

1057

Tell me what is the difference between locking and multi-versioning?

1029

Why do we backup Active Directory ?

1042

What is bcp? When does it used?

976

What are unicode character string data types in ms sql server?

1255

What is failover clustering overview?

1089

What are “unrepeatable reads”?

1234

please differentiate between delete and truncate?

993

What is buffer cash in sql server?

1152

What is store procedure? How do they work? When do you use?

942

Which sql server table is used to hold the stored procedure scripts?

1061