SQL Server database consists of three types of files namely primary, secondary and transaction log files. Primary and secondary data files can store data in the database while transaction log files helps to hold transaction information that is used to recovering data at the time of disaster. While creating a database in the MS SQL Server, it automatically creates two types of files the primary or MDF and log or LDF files. SQL Server treats the MDF file as primary database file to store all the data. Again each MDF file has a LDF file that is associated with MDF files.
Jacob Martin is a technology enthusiast having experience of more than 4 years with great interest in database administration. He is expertise in related subjects like SQL database, Access, Oracle & others. Jacob has Master of Science (M.S) degree from the University of Dallas. He loves to write and provide solutions to people on database repair. Apart from this, he also loves to visit different countries in free time.