Interested to Buy Any Domain ? << Click Here >> for more details...
What are mdf,ndf,ldf files and how to see the data in those
files?
- 6 Answers
- 60212 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / ravi santlani
MDF is the main database files - It's a SQL Data files where all the data in the database objects are stored in. (like tables, stored procedures, views, triggers etc are stored in the mdf file of sql server). This is the reason whey we use .MDF file to attache the database. Once we attach the .mdf we were able to see all the data exist in that respective database.
LDF is the log files - The size of the log file(ldf) is determined my the logging level you have set up on the database. Simple, full, and buld logged are the options. Simple being the least, and full being the most. The log (if in full) will alow you to re-apply transactions to the databse incase of a failure. If your looking for some performance improvement, there are a lot of things that can be done.
Just to focus on the files you could more the location of the LDF file to a separate physical drive. This will increate performance because writing to the log and writing to the mdf files wont compete for each other for throughput tot he drive.
NDF are secondary databse files (Same as mdf, but you can only have 1 Main database file).
You can also create a NDF file for the databese, and change some of the tables to be stored on this NDF. This file also could be stored on a separate physical drive. Some advantages to this are:
Tables that are written to most frequently are stored in one file, and tables that are relatively static are in another. Having to smaller file to write to for transactions will help with throughput.
| Is This Answer Correct ? | 46 Yes | 6 No |
Post New Answer View All Answers
Tell me what are the essential components of sql server service broker?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Do you think BCNF is better than 2NF & 3NF? Why?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What does indexation mean?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Can two tables have the same primary key?
What is cursors? And what are the different types of cursor?
What is shared lock?
Explain the stored procedure?
What happens if you add a new index to large table?
What is nested transaction?
How to rebuild all indexes on a single table?
What is instead of dml trigger?
What is not null constraint?
