- 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.
Groups are used to logically group database files. E.g Sales.ndf, Finance.ndf, HR.ndf