Saturday, November 23, 2013

Sql server database files

Sql server database have three type of file 

1) Primary data files
2) Secondary data files
3) log files

What are primary data files?

The primary data file is the starting point of the database
 primary data file also called .MDF.

What are secondary data files?

Secondary data files is optional data file. IT can be used for spreading data on the different storage media .
Secondary data files also called .NDF

What is log files?

The log files contain log information of the database  that is used to recover the data.
  • Log file also called .ldf file
  • Every database have at least one  log file .
  • .MDF – primary database file
  • .NDF- secondary data files
  • .LDF- log file.  
 


at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

sql server index

sql index An index is an internal table structure that sql server uses to provide quick access to rows of a table based on the values...

  • SQL Server improving
    In the ten years since release of Microsoft's previous SQL Server product (SQL Server 2000), advancements have been made in performance...
  • T-SQL tutorial
    Welcome to beginner to advance T-SQL tutorial. In this tutorial I have explained you about basic to advance T-SQL statement .This tutorial ...
  • Transact-SQL using for SQL Server
    create a table simple tableperson  create table person (     p_id  int,     firstname varchar(50),      lastname varchar(50),     addr...