![]() ![]() A more complex database named Orders can be created that includes one primary file and five secondary files. ldf.įor example, a simple database named Sales has one primary file that contains all data and objects and a log file that contains the transaction log information. The recommended file name extension for transaction logs is. There must be at least one log file for each database. The log holds information used to recover the database. The recommended file name extension for secondary data files is. Data can be spread across multiple disks by putting each file on a different disk drive. The recommended file name extension for primary data files is. Every database has one primary data file. FileĬontains startup information for the database and points to the other files in the database. SQL Server databases have three types of files, as shown in the following table. Data files can be grouped together in filegroups for allocation and administration purposes. Log files contain the information that is required to recover all transactions in the database. ![]() Data files contain data and objects such as tables, indexes, stored procedures, and views. At a minimum, every SQL Server database has two operating system files: a data file and a log file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |