—Microsoft SQL Server uses three types of
files to store databases
1.Primary data files, which
have an .mdf extension
. which can
contain user-defined
objects,
such as tables and views>
2.If the database becomes too large and you
run out of room on your first hard disk, you can create secondary data files,
which have an .ndf extension,
— transaction log file.
Transaction log files use an .ldf extension
—Microsoft database server can have
default instance or several named instance of sql server.
المشاركات
ليست هناك تعليقات:
إرسال تعليق