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
- 60136 Views
- Accenture, I also Faced
- E-Mail Answers
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
Which database stores information about replication?
What is use of @@ spid in sql server?
How will you decide the active and passive nodes?
What is the difference between drop table and truncate table?
How to search for a string in all stored procedure in sql server?
How many types of local tables are there in sql server?
What are the recovery models for a database?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Give the query of getting last two records from the table in SQL SERVER?
Explain indexed views and partitioned view with their syntax.
What is the user of Primary key?
What are the built in functions in sql server?
What are the functions in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file?
Can a trigger be created on a view?
