What are mdf,ndf,ldf files and how to see the data in those
files?
Answer Posted / padma
When we create a db,the create command will create a data
file with an Extension .mdf,as well as a transaction log
file with extension .ldf
Any additional or secondary data files have .ndf extension
| Is This Answer Correct ? | 121 Yes | 22 No |
Post New Answer View All Answers
What objects does the fn_my_permissions function reports on? : sql server security
What does dml stand for?
What is normalization? Explain different forms of normalization?
Explain datetime2 data type in sal server 2008?
What is the difference between count and distinct count?
How much memory that we are using in Logshipping Concept?
What is amo? : sql server analysis services, ssas
How to drop an existing stored procedure in ms sql server?
What is meant by indexing?
What is conditional split?
How do I schedule a sql server profiler trace?
How to transfer an existing table from one schema to another schema in ms sql server?
What does normalization do to data?
How to backup SQL Server Reporting Services ?
How to perform key word search in tables?