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


Please Help Members By Posting Answers For Below Questions

Explain transaction isolation levels in sql server?

545


What is snapshot parameter in ssrs?

109


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

573


What happens to a statement batch if there is a compilation error?

507


Explain data warehousing in sql server?

602






How to provide login information for a new odbc dsn?

536


What is openrowset sql server?

518


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

518


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

651


What happens if null values are involved in string operations?

554


Will the writetext statement activate a trigger?

566


what are the different types of SSRS reports?

112


What is tabulation?

553


What is bookmark link in ssrs?

108


What does this statement do @@rowcount?

548