- 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
