Sunday, December 3, 2017

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   


No comments:

Post a Comment