Hands-On Projects Hands-On Project 8-1: Recovering from Accidental Deletion of Data For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA and the HandsOnOne database and tables that you created in previous chapters. The objective of this project is to practice recovering data that was accidentally deleted by a user. Document each step by taking screen shots of the configuration settings and/or query execution results. 1. In SQL Server Management Studio, create a new backup device named HandsOnOne in 2. Perform a full backup of the HandsOnOne database to the HandsOnOne backup 3. Use Query Editor to create and execute a SQL statement that returns all records from . In this step, you will simulate the accidental deletion of all records from the customer the destination folder CABackupl device the customer table. table. Use a second Query Editor window to create and execute a SQL statement that deletes all records from the customer table in the HandsOnOne database 5. Back up the tail of the HandsOnOne database transaction log, appending it to the exist 6. Restore the HandsOnOne database to the point in time prior to the deletion of cus- 7. Use a new Query Editor window to write and execute a SQL statement that returns all ing backup set. tomer records. records from the customer table in order to validate that the customer records deleted in Step 3 have been successfully recovered