What Are Database Files And Filegroups?

1.	What Are Database Files And Filegroups?
Answer» 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 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

Answer»

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

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

What Are Database Files And Filegroups?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment