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

No comments: