Data Disk Storage, Backup, and Recovery

docx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

400

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

3

Report

Uploaded by JudgeFerretPerson948

Shannabeth Paine SYM-400 Professor Doyle 08/25/2023 Data Disk Storage, Backup, and Recovery In 200–250 words, explain the process of storing database data on a disk. 1. Using what you have learned from the topic Resources, run a complete backup of the database. Take screenshots of each step used to execute the backup process. Paste the screenshots into the Word document as a record of the process. Databases from Microsoft SQL Server are contained in two folders on the disk: a record file and a log file. Main or secondary data files can be included. The primary files contain database startup details and point to other files in the database. This file will store user data and artifacts and each database has one primary data file. Secondary data files are optional and can be used by placing each file on a separate disk drive to distribute data through several files/disks. SQL may have just one main data file, but to keep the data balanced, I can have as many separate data and log files as possible. The details files are split down into 8KB pages. That in memory and on disk is the smallest storage unit. Only one table is devoted to each page. SQL Server assigns pages to all data files if many data files occur inside a filegroup, relying on a round-robin mechanism called the proportional fill algorithm. The sum of data on each page will be calculated depending on the free space that each page has now. In general, both pages can fill up at the same time. 2. Run a complete restore of the database. Take screenshots of each step used to complete the restore process. Paste the screenshots into the Word document as a record of the process.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Solved 10 Network topology(1)(1).docx
COMP2129_assignment1_2023.docx
WEEK 4.docx
BMEN 3311 Lab 1 F2023.docx
sample-final.pdf
FOR ONLINE TOOL.docx
12-4e Capstone Projects.docx
ANT200_Exe3_GIS.docx
12-4d Hands-On Projects.docx
Week 5 forum.docx
AB1.pdf
COMP2336_Assignmet_2.docx
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
SEE MORE TEXTBOOKS