Kutztown University of Pennsylvania Computer Science Question – Description
Assignment 7 (10 points): Read Chapter 10 of the SQL Server 2022 Administration Inside Out textbook and answer the following questions in a Word file. Copy and paste the following questions into your Word file and then answer the questions.
Note: You may need to Google to answer a few questions appropriately.
Question 1: What is a disaster recovery scenario? Why is this important? How will you solve it in SQL Server 2022? Explain each part in at most six lines. (2 points)
Question 2: How many backups do we have in SQL Server 2022? What are the differences between them? Write each type of backup using the T-SQL command in one line. (3 points)
Question 3: Create a backup for your database bikestores of assignment 6 using the T-SQL command. Restore your database using the T-SQL command. Explain your T-SQL queries using the appropriate English language. (2 points)
Question 4: What is the best recovery strategy for your database bikestores in assignment 6? Explain all the possible scenarios, compare them, and describe your solution with good arguments. (3 points)
Instructions:
1) Upload a doc or docx file to Canvas before the deadline, July 6, 2023, at 11:58 pm.
This assignment will shape 10% of your final grade for the course CTS 4408 Database Administration using Microsoft SQL Server 2022.
The post Kutztown University of Pennsylvania Computer Science Question first appeared on .
