Question: 1. Using your existing database, Backup and Restore your database Provide the SQL scripts and screenshot of the steps you took to complete this

1. Using your existing database, Backup and Restore your database Provide the SQL scripts and screenshot of

1. Using your existing database, Backup and Restore your database Provide the SQL scripts and screenshot of the steps you took to complete this task 2. Provide a response to the following questions: a. Name the different types of recovery and discuss the factors that influence when each type of recovery should be performed b. Name and describe the three types of database failures that may require recovery c. What is meant by the term log archival, and why is it important to assure recoverability? What to Submit 1. A SINGLE .sql file with the following: a. SQL queries used to backup and recover the database 2. A WORD document with screenshots of all steps taken to backup and recover the database 3. In the same WORD document, include your detailed response to Part 2 of the assignment 2. **In the SQL file - add appropriate comments at the top of the query file. Include - Name, assignment #, date of the assignment Prefix the Naming convention of each file with firstNameLastname_Module4Assignment

Step by Step Solution

3.47 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Stepbystep instructions for backing up and restoring a database Backup Create a backup directory This directory should be located on a separate storage device from the database itself Use a backup too... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!