Showing posts with label Each database file has five properties. Show all posts
Showing posts with label Each database file has five properties. Show all posts

Each database file has five properties

Each database file has five properties:

1) Logical File Name : Name
2) Physical File Name : Filename
3) Initial Size : Size
4) Maximum Size : Maxsize
5) Growth increment : Growth

After Creating the Database server arranges internally two files.

A) Primary File: It was defined by the server with 0.63mb size and with extension ".mdf" (master data file) for holding start up information of the database.

Example: NRSTT.Mdf

B) Log File: It was defined by the server with 0.40mb size and with extension ".ldf" (log data file) for holding transaction information of the database.

Example: NRSTT.ldf
Share/Bookmark