Data Disk Storage, Backup, and Recovery
.docx
School
Grand Canyon University**We aren't endorsed by this school
Course
SYM 400
Subject
Computer Science
Date
Jan 5, 2025
Pages
2
Uploaded by CoachFogMandrill45
Sandra NarongSYS 400 – Introduction to Database StructureDr. Brian LetortData Disk Storage, Backup, and RecoverySQL Servers have two folders that are on the disk, they are a record file and a log file. A main or secondary data file can also be included. In the primary files, database startup details and point to other files that are within the database. This file will store user data, artifacts, and each database has one primary data file. Secondary data files are optional. Data files have the schema and data in objects such as tables and indexes whereas log files contain the transaction log recorders that are used to maintain the integrity of the database. The data is stored in pages that are 8 KB blocks. Pages are grouped in collections of 8 contiguous pages. SQL uses a “Write-Ahead Logging” protocol that ensures that there is no modifications that are written into disk before the associate log record is written. This will allow and maintain data integrity.
