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

Explain go command in sql server?

1010

What is cached report?

143

What do you mean by data integrity?

1045

What are the differences between stored procedure and the dynamic sql?

1067

Give the query of getting last two records from the table in SQL SERVER?

928

How to execute the cursor queries with "open" statements?

1158

What is raiseerror? What is raiseerror?

1117

What number sorts of privileges are accessible in sql?

1016

Can you tell me some of the common replication dmv's and their use? : sql server replication

902

Can we take the full database backup in log shipping?

930

What is the difference between the 2 operating modes of database mirroring?

1090

List the different types of joins?

966

Does sql server 2000 clustering support load balancing?

950

what are constraints? Explain different types of constraints? : Sql server database administration

958

What is model database in sql server?

1032