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   

                                                                                     
                                                       

1 comment:

  1. This website can live streaming , you can join at my site :
    agen judi online terpercaya
    Prediksi Bola

    Thank you
    agenpialaeropa.club
    gamesonline.ga
    beritasemasaterikini.net

    ReplyDelete