What are the three types of Database files?

          
Interview questions

Types of Database files

<<Previous   Next>>

Sql server  - types of Database files - Feb 27, 2010 at 19:00 PM by Shuchi Gauri

What are the three types of Database files? Explain them.

Types of database files:

  • Data file: This stores all the data. It has an extension .mdf
  • Log file: This stores all the transaction log information. It has an extension .ldf
  • Additional data files: Any additional data is stored in these files. It has an extension .ndf

Sql server  - types of Database files - March 02, 2009 at 22:00 PM by Rajmeet Ghai

What are the three types of Database files? Explain them. 

Database files are used for mapping the database over some operating system files. Data and log information are separate. SQL server database has three types of database files:

Primary: starting point of a database. It also points to other files in database. Extension: .mdf

Secondary: All data files except primary data file is a part of secondary files. Extension: .ndf

Log files: All log information used to recover database. Extension: .ldf 

<<Previous   Next>>
 

Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
 
Home | Want a Job? Submit Key Skills | Employer login | My key skills | About us | Sitemap | Contact us