SQL Server - Database Architecture

• Database is a place in the SQL Server where we store the data. It the collection of tables, views, stored procedures, users, roles etc
• SQL server uses two types of files to store the database information. One or more database files and one or more transaction log files.
• Database files : Primary data file with.mdf extension, secondary data file with .ndf extension and transaction log file with .ldf extension.
• File Groups are used to logically group database files.  E.g Sales.ndf, Finance.ndf, HR.ndf