SQL Server handles the
bulky database of organizations. SQL supports two operating files one is data
file and another is log files. There are three different formats for each file
mdf and ndf file formats are for data files and all logs files are stored as
.ldf format. The data file contains all the records, tables, indexes, views and
stored procedure and all the transactions taken place in the database are being
stored in log files. Later these log files can be used to recover all the
transaction done in the database. As SQL Server is the best application but the
default fact is that this is not immune to corruption. Mostly the issue involve
in corruption is the repair of database so for this user mostly go for manual
repair but there are certain issues involved with manual solution which may
leads to failure of the manual solution in recovering database. So SQL Database Repair can be used in this case.
Types of database Files in SQL
Server
SQL
support three file formats for data and log storage. For the primary data .mdf
files are used it store the master data and also known as master data files and
for the secondary database .ndf files are defined. All the transaction
information or can say log data are stored using .ldf format and referred as
log files or transaction log files. Basically your secondary database files are
optional one and the master database files are the permanent one. That means a
database will surely have one .mdf file but the existence of .ndf is optional.
Types of Filegroups in SQL Server
SQL
Server supports two filegroups. There is a primary filegroup which exist for
every database and secondary filegroups are being created by the user. The
primary filegroup contains all the primary files and system files are also
allocated in the Primary filegroup. The user-defined filegroup contain
secondary files created by the user.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.