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 are the new security features added in sql server 2012? : sql server security
Define Wed Edition in SQL Azure?
Explain what is the difference between a local and a global temporary table?
How do I edit a stored procedure in sql server?
Can you explain different types of joins?
What is the difference between clustered index and primary key?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Difference between DELETE and TRUNCATE?
What are the methods used to protect against sql injection attack?
What is the use of “join” in sql server?
Define Business Edition in SQL Azure?
What is the xml datatype?
Which Model uses the SET concept
What is resource governor?
Where sql server user names and passwords are stored in sql server? : sql server database administration