MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462) 1st edition

Complete the steps in Microsoft SQL Server and take screenshots for each step. Include steps on how you got to the screenshot if possible. Thanks!

Use Sql Server Express to complete this. It is free and takes 5 minutes to download.

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 cach step by taking screen shots of the configuration settings and/or query exccution rcsults. 1. In SQL Server Management Studio, create a new backup device named HandsOnOne in the destination folder C:lBackup 2. Perform a full backup of the HandsOnOne database to the HandsOnOne backup 3. Use Qucry Editor to create and exccute a SQL statement that returns all records from 4. In this step, you will simulate the accidental deletion of all records from the customer 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 databasc 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 sct. tomer records. records from the customer table in order to validate that the customer records deleted in Step 3 have been successfully recovered