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
No comments:
Post a Comment