TABLES FOR THE ASSIGNMENT

CREATE TABLE CustomerService.Reps

(

RepID int IDENTITY(1,1),

CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID),

BusinessEntityID int not null,

CONSTRAINT FK_BusinessEntityID FOREIGN KEY (BusinessEntityID)

REFERENCES Person.Person (BusinessEntityID),

SupervisorID int not null,

CONSTRAINT FK_SupervisorID FOREIGN KEY (SupervisorID)

REFERENCES Person.Person (BusinessEntityID),

)

ON AD_CustomerService

GO

ALTER TABLE CustomerService.Reps

REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE);

GO

CREATE UNIQUE INDEX idx_BusinessEntityID

ON CustomerService.Reps (BusinessEntityID)

WITH(SORT_IN_TEMPDB = ON, ONLINE=ON)

ON AD_CustomerService;

GO

CREATE TABLE CustomerService.Contacts

(

--A

ContactID int IDENTITY(1,1),

CONSTRAINT PK_ContactID PRIMARY KEY CLUSTERED (ContactID),

--B

CustomerID int not null,

CONSTRAINT FK_CustomerID FOREIGN KEY (CustomerID)

REFERENCES Sales.Customer (CustomerID),

--C

RepID int not null,

CONSTRAINT FK_RepID FOREIGN KEY (RepID)

REFERENCES CustomerService.Reps (RepID),

--D

ContactDateTime date not null,

--E

ContactMethod varchar(5) DEFAULT 'Other' not null,

CHECK (ContactMethod IN ('Email', 'Phone', 'Chat', 'Other')),

--F

ContactPhone varchar(14) null,

--G

ContactEmail varchar(50) null,

--H

ContactDetail varchar(MAX) not null,

)

ON AD_CustomerService;

GO

ALTER TABLE CustomerService.Contacts

REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE);

GO

CREATE INDEX idx_CustomerID

ON CustomerService.Contacts (CustomerID)

WITH(SORT_IN_TEMPDB = ON, ONLINE=ON)

ON AD_CustomerService;

GO

CREATE INDEX idx_RepID

ON CustomerService.Contacts (RepID)

WITH(SORT_IN_TEMPDB = ON, ONLINE=ON)

ON AD_CustomerService;

GO

CREATE INDEX idx_ContactDateTime

ON CustomerService.Contacts (ContactDateTime)

INCLUDE (ContactMethod)

WITH(SORT_IN_TEMPDB = ON, ONLINE=ON)

ON AD_CustomerService;

GO

CREATE TABLE CustomerService.Attachments

(

--A

AttachmentID int IDENTITY(1,1),

PRIMARY KEY (AttachmentID),

--B

ContactID int not null,

FOREIGN KEY (ContactID) REFERENCES CustomerService.Contacts (ContactID),

--C

AttachmentDateTime datetime not null,

--D

AttachmentName varchar(50) not null,

--E

Attachment varbinary(MAX) not null,

)

ON AD_CustomerService;

GO

ALTER TABLE CustomerService.Attachments

REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE);

GO

CREATE INDEX idx_ContactID

ON CustomerService.Attachments (ContactID)

WITH(SORT_IN_TEMPDB = ON, ONLINE=ON)

ON AD_CustomerService;

GO

1) USE THIS WORD DOC AND INSERT THE DELIVERABLES WHERE INDICATED - PLEASE NOTE THAT ALL SCREENSHOTS SHOULD BE FULL-SCREEN SCREENSHOTS (no cropped screenshots) ADDITIONAL NOTE: You may want to create a special directory that is easy to remember to store these backups. This will make it simpler to perform the restores. 2) Change the Adventure Works2014 database to Recovery Mode = FULL (database options) 3) Create a FULL backup of the AdventureWorks2014 database using the CHECKSUM and COMPRESSION options. This backup should include the tables and indexes created in assignment 3. 4) ($$)DELIVERABLE Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 5) Perform the following inserts: use Adventureworks 2014 insert into Customer Service Reps values (276, 285) insert into Customer Service. Reps values (277, 285) insert into Customer Service. Reps values (278, 285) insert into Customer Service. Reps values (279, 285) insert into Customer Service Reps values (280, 285) insert into Customer Service. Reps values (281, 285) insert into Customer Service. Reps values (282, 285) 6) Create a DIFFERENTIAL backup of the AdventureWorks2014 database using the CHECKSUM & COMPRESSION options. 7) ($$)DELIVERABLE Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 8) Perform the following inserts: use AdventureWorks 2014 insert into Customer Service Contacts values (384,1, CURRENT_TIMESTAMP, 'Phone', '612- 555-4492',NULL,'Customer called to ask about delivery delay with order #4531') insert into Customer Service. Contacts values (191,1, CURRENT_TIMESTAMP, 'Email', '734- 555-9485',NULL, 'Customer called to discuss new order for product XYZ') ***These inserts may work or fail using the values provided above - it depends on your previous insert attempts and how they impacted your Identity property counter. If these fail due to a Foreign Key constraint violation, then the resolution is simple - Just alter your second input value (1 in the above example) to a valid RepID from your Reps table. 9) Create a TRANSACTION LOG backup of the Adventure Works2014 database using the CHECKSUM & COMPRESSION options. 10) ($$)DELIVERABLE - Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 11) Perform the following insert: use AdventureWorks 2014 /******FOR THE FOLLOWING, PLEASE CHANGE "C:\pick a file" TO REFER TO ANY FILE ON YOUR PC AND RUN ALL OF THESE COMMANDS AT THE SAME TIME******/ DECLARE @jpg VARBINARY (MAX) SELECT @jpg Bulkcolumn FROM OPENROWSET (BULK N's:\pick a file', SINGLE_BLOB) AS Document INSERT INTO Customer Service.Attachments ContactID, AttachmentDateTime, AttachmentName, Attachment) values (2, CURRENT_TIMESTAMP, 'Picture of damage@irg) ***This insert may work or fail using the values provided above - it depends on your previous insert attempts and how they impacted your Identity property counter. If these fail due to a Foreign Key constraint violation, then the resolution is simple - Just alter your first input value (2 in the above example) to a ContactID from the Contacts table. 12) ($$)DELIVERABLE - Take a screenshot of the "SELECT TOP 1000 ROWS" from each of the three tables and attach to the word doc below: 13) Create a FULL backup of the Master database using the CHECKSUM & COMPRESSION options. 14) ($$)DELIVERABLE Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 15) Create a FULL backup of the MSDB database using the CHECKSUM & COMPRESSION options. 16) ($$)DELIVERABLE - Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. NOW, LET'S BREAK THE ADVENTUREWORKS2014 DATABASE 17) Perform the following command in a new query window: DBCC IND AdventureWorks 2014, 'Customer Service. Contacts', 1) 18) ($$)DELIVERABLE - Take a screenshot of the output and attach it to the word doc below. It should look something like the following: DBCC IND Adventureworks 2014, 'Customer Service.Contacts', 1) 100 % Results Messages PageFID PagePID IAMFID TAMPID ObjectID IndexID Partition Number 1 13 13 NULL NULL 1959678029 1 1 2 3 12 3 13 1959678029 1 1 PartitionID iam_chain_type 72057594061389824 In row data 72057594061389824 In-row data Page Type IndexLevel Next Page FID 10 NULL 0 1 0 0 19) Identify the PageFID and PagePID for the row with a PageType of 1. In the example above, the PageFID=3 and the PagePID=12, but yours could be different. 20) With this information, execute the following commands replacing the PageFID (second parameter and PagePID (third parameter) with your values. If you do not replace the values with yours, you can cause irreparable damage to your database. All the rest can remain the same: ALTER DATABASE Adventureworks 2014 SET SINGLE USER WITH ROLLBACK IMMEDIATE DBCC WRITEPAGE('Adventureworks 2014', 3, 12, 60, 1, 0x00, 1) Alter DATABASE Adventureworks 2014 SET MULTI_USER 21) Execute the following queries: use Adventureworks 2014 select * from Customer Service. Reps use AdventureWorks 2014 select * from Customer Service. Contacts 22) ($$)DELIVERABLE Take a screenshot of the output and attach it to the word doc below. QUESTION: Do both queries fail? What's the error? Provide answers in the word doc below: NOW, LET'S RECOVER THE ADVENTUREWORKS 2014 DATABASE 23) Perform a TAIL LOG backup of the AdventureWorks 2014 database such that the database is no longer available for use. NOTE: YOU WILL NEED TO CLOSE ALL OF YOUR ACTIVE 23) Perform a TAIL LOG backup of the AdventureWorks 2014 database such that the database is no longer available for use. NOTE: YOU WILL NEED TO CLOSE ALL OF YOUR ACTIVE CONNECTIONS. 24) ($$)DELIVERABLE - Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 25) Perform a FULL Restore of the AdventureWorks 2014 database with the NORECOVERY option. 26) ($$)DELIVERABLE Add the T-SQL used for the restore to the word doc below. Use SCRIPT function in SSMS, if performing restore through SSMS. 27) Perform a Differential Restore of the Adventure Works2014 database with the NORECOVERY option. 28) ($$)DELIVERABLE Add the T-SQL used for the restore to the word doc below. Use SCRIPT function in SSMS, if performing restore through SSMS. 29) Perform both Transaction Log Restores of the AdventureWorks 2014 database with the NORECOVERY option. 30) ($$)DELIVERABLE - Add the T-SQL used for the restore to the word doc below. Use SCRIPT function in SSMS, if performing restore through SSMS. 31) Perform a database restore of the AdventureWorks2014 database with the RECOVERY option. 32) ($$)DELIVERABLE Add the T-SQL used for the restore to the word doc below. Use SCRIPT function in SSMS, if performing restore through SSMS. 33) ($$)DELIVERABLE - Take a screenshot of the "SELECT TOP 1000 ROWS" from each of the three Customer Service schema tables and attach to the word doc below. Any errors? Do they match Customer Service schema tables and attach to the word doc below. Any errors? Do they match previous values? Provide answers below: 34) Go to the backup and restore reports for the Adventure Works2014 database in SSMS as follows: 0 Solution - Microsoft SQL Server Management Studio File Edit View Project Debug Tools Window Help 10.1.2 New Query DDB XB-N- Registered Servers Database Engine Object Explorer Connect - 703 E MOMDAD (SQL Server 120.25600 - MOMDADVOwner) Databases System Databases Database Snapshots New Database... New Query Script Databases Tasks Policies Facets Start PowerShell Disk Usage Disk Usage by Top Tables Disk Usage by Table Disk Usage by Partition Backup and Restore Events All Transactions All Blocking Transactions Top Transactions by Age Top Transactions by Blocked Transactions Count Top Transactions by Locks Count Resource Locking Statistics by Objects Object Execution Statistics Database Consistency History Memory Usage By Memory Optimized Objects Index Usage Statistics Index Physical Statistics Schema Changes History User Statistics P2 Sec Ser | Rep Alw Mar Inte SOL Reports Standard Reports Rename Delete Custom Reports Backup and Restore Events Disk Usage Refresh Properties Ready Ago 10:20 PM 1/28/2017 e 35) Expand the "Successful Backup Operations" and "Successful Restore Operations portions. It should look like the below: Backup and Restore Events - 1/28/2017 10:21 PM - MOMDAD - Microsoft SQL Server Management Studio File Edit View Project Debug Tools Window Help BH 2 New Query DEOS Registered Servers Backup and Resto...021 PM - MOMDAD X a Database Engine User Name Recovery Model Dillerertid Rase LSN Successful Backup Operations Duration Start Time minutes) Backup Type Backup Size Backup Name 1/28/2017 Database 9:41:18 PM AdvertureWorks2014-F ME Differential Database Backup 1/28/2017 022 Database 190.08 MB Adventure Works2014 11:07:19 AM Database Backup 7/17/2014 0.07 4:18:18 PM Database Adventure Works2014-ful 000 Device Type Da temporary De temporal Disk terror Mom Dad Owner SIMPLE Mom Dad Owner SIMPLE VCG souley SIMPLE 48000000001600159 49 Not oplicable 48 Not applicable 45 190.08 MB Die Back Backup Operation Errors Show details of the errors, which caused the backup operation failure in the recent post No backup operatione non occured for Adverture Vaka2014 database in the recent part, er delal race a not enabled Object Explorer Connect - 373 MOMDAD (SOIL Server 120.25690 - MOMDADVOwner) Databases System Databases Database Snapshots Adventure Works2014 Azure Test BUCompany henry premiere ReportServer Report Server TempDB sysutility_mw Security Server Objects Replication Always On High Availability Management Integration Services Catalogs SQL Server Agent Success Restore Operatione Date Time Destination Recovery Option User Restore Mode Type Dertil No replace 1/28/2017 10:19:16 PM Adverture Worka2014 Recovery Mon Dad Owner 1/28/2017 10:19:12 PM Adventure Works 2014 Database No replace No recovery MonDad Owner Backup Nene Adverture Works:20 14. Database Backup Adventure Works 20 14-Full Database Backup Adventure Works20 14 Full Database Adventure Works20 14 Full Database 1/28/2017 10:18:47 PM Adventure Worka 2014 Database No replace No recovery MonDad Owner Backup 1/3/2017 1059 45 AM Adventure Worka2014 Database No replace Recovery Mon Dad Owner Ready 10:22 PM 1/28/2017 36) ($$)DELIVERABLE (20 points) Take a screenshot (or two if necessary) showing all of the events in both sections and add it to the word doc below: 37) If working on a lab machine, remember to backup your databases onto the U: drive to restore for your next assignment. Lab machine users will not be able to continue to the extra credit exercise. 1) USE THIS WORD DOC AND INSERT THE DELIVERABLES WHERE INDICATED - PLEASE NOTE THAT ALL SCREENSHOTS SHOULD BE FULL-SCREEN SCREENSHOTS (no cropped screenshots) ADDITIONAL NOTE: You may want to create a special directory that is easy to remember to store these backups. This will make it simpler to perform the restores. 2) Change the Adventure Works2014 database to Recovery Mode = FULL (database options) 3) Create a FULL backup of the AdventureWorks2014 database using the CHECKSUM and COMPRESSION options. This backup should include the tables and indexes created in assignment 3. 4) ($$)DELIVERABLE Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 5) Perform the following inserts: use Adventureworks 2014 insert into Customer Service Reps values (276, 285) insert into Customer Service. Reps values (277, 285) insert into Customer Service. Reps values (278, 285) insert into Customer Service. Reps values (279, 285) insert into Customer Service Reps values (280, 285) insert into Customer Service. Reps values (281, 285) insert into Customer Service. Reps values (282, 285) 6) Create a DIFFERENTIAL backup of the AdventureWorks2014 database using the CHECKSUM & COMPRESSION options. 7) ($$)DELIVERABLE Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 8) Perform the following inserts: use AdventureWorks 2014 insert into Customer Service Contacts values (384,1, CURRENT_TIMESTAMP, 'Phone', '612- 555-4492',NULL,'Customer called to ask about delivery delay with order #4531') insert into Customer Service. Contacts values (191,1, CURRENT_TIMESTAMP, 'Email', '734- 555-9485',NULL, 'Customer called to discuss new order for product XYZ') ***These inserts may work or fail using the values provided above - it depends on your previous insert attempts and how they impacted your Identity property counter. If these fail due to a Foreign Key constraint violation, then the resolution is simple - Just alter your second input value (1 in the above example) to a valid RepID from your Reps table. 9) Create a TRANSACTION LOG backup of the Adventure Works2014 database using the CHECKSUM & COMPRESSION options. 10) ($$)DELIVERABLE - Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 11) Perform the following insert: use AdventureWorks 2014 /******FOR THE FOLLOWING, PLEASE CHANGE "C:\pick a file" TO REFER TO ANY FILE ON YOUR PC AND RUN ALL OF THESE COMMANDS AT THE SAME TIME******/ DECLARE @jpg VARBINARY (MAX) SELECT @jpg Bulkcolumn FROM OPENROWSET (BULK N's:\pick a file', SINGLE_BLOB) AS Document INSERT INTO Customer Service.Attachments ContactID, AttachmentDateTime, AttachmentName, Attachment) values (2, CURRENT_TIMESTAMP, 'Picture of damage@irg) ***This insert may work or fail using the values provided above - it depends on your previous insert attempts and how they impacted your Identity property counter. If these fail due to a Foreign Key constraint violation, then the resolution is simple - Just alter your first input value (2 in the above example) to a ContactID from the Contacts table. 12) ($$)DELIVERABLE - Take a screenshot of the "SELECT TOP 1000 ROWS" from each of the three tables and attach to the word doc below: 13) Create a FULL backup of the Master database using the CHECKSUM & COMPRESSION options. 14) ($$)DELIVERABLE Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 15) Create a FULL backup of the MSDB database using the CHECKSUM & COMPRESSION options. 16) ($$)DELIVERABLE - Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. NOW, LET'S BREAK THE ADVENTUREWORKS2014 DATABASE 17) Perform the following command in a new query window: DBCC IND AdventureWorks 2014, 'Customer Service. Contacts', 1) 18) ($$)DELIVERABLE - Take a screenshot of the output and attach it to the word doc below. It should look something like the following: DBCC IND Adventureworks 2014, 'Customer Service.Contacts', 1) 100 % Results Messages PageFID PagePID IAMFID TAMPID ObjectID IndexID Partition Number 1 13 13 NULL NULL 1959678029 1 1 2 3 12 3 13 1959678029 1 1 PartitionID iam_chain_type 72057594061389824 In row data 72057594061389824 In-row data Page Type IndexLevel Next Page FID 10 NULL 0 1 0 0 19) Identify the PageFID and PagePID for the row with a PageType of 1. In the example above, the PageFID=3 and the PagePID=12, but yours could be different. 20) With this information, execute the following commands replacing the PageFID (second parameter and PagePID (third parameter) with your values. If you do not replace the values with yours, you can cause irreparable damage to your database. All the rest can remain the same: ALTER DATABASE Adventureworks 2014 SET SINGLE USER WITH ROLLBACK IMMEDIATE DBCC WRITEPAGE('Adventureworks 2014', 3, 12, 60, 1, 0x00, 1) Alter DATABASE Adventureworks 2014 SET MULTI_USER 21) Execute the following queries: use Adventureworks 2014 select * from Customer Service. Reps use AdventureWorks 2014 select * from Customer Service. Contacts 22) ($$)DELIVERABLE Take a screenshot of the output and attach it to the word doc below. QUESTION: Do both queries fail? What's the error? Provide answers in the word doc below: NOW, LET'S RECOVER THE ADVENTUREWORKS 2014 DATABASE 23) Perform a TAIL LOG backup of the AdventureWorks 2014 database such that the database is no longer available for use. NOTE: YOU WILL NEED TO CLOSE ALL OF YOUR ACTIVE 23) Perform a TAIL LOG backup of the AdventureWorks 2014 database such that the database is no longer available for use. NOTE: YOU WILL NEED TO CLOSE ALL OF YOUR ACTIVE CONNECTIONS. 24) ($$)DELIVERABLE - Add the T-SQL used for the backup to the word doc below. Use SCRIPT function in SSMS, if performing backup through SSMS. 25) Perform a FULL Restore of the AdventureWorks 2014 database with the NORECOVERY option. 26) ($$)DELIVERABLE Add the T-SQL used for the restore to the word doc below. Use SCRIPT function in SSMS, if performing restore through SSMS. 27) Perform a Differential Restore of the Adventure Works2014 database with the NORECOVERY option. 28) ($$)DELIVERABLE Add the T-SQL used for the restore to the word doc below. Use SCRIPT function in SSMS, if performing restore through SSMS. 29) Perform both Transaction Log Restores of the AdventureWorks 2014 database with the NORECOVERY option. 30) ($$)DELIVERABLE - Add the T-SQL used for the restore to the word doc below. Use SCRIPT function in SSMS, if performing restore through SSMS. 31) Perform a database restore of the AdventureWorks2014 database with the RECOVERY option. 32) ($$)DELIVERABLE Add the T-SQL used for the restore to the word doc below. Use SCRIPT function in SSMS, if performing restore through SSMS. 33) ($$)DELIVERABLE - Take a screenshot of the "SELECT TOP 1000 ROWS" from each of the three Customer Service schema tables and attach to the word doc below. Any errors? Do they match Customer Service schema tables and attach to the word doc below. Any errors? Do they match previous values? Provide answers below: 34) Go to the backup and restore reports for the Adventure Works2014 database in SSMS as follows: 0 Solution - Microsoft SQL Server Management Studio File Edit View Project Debug Tools Window Help 10.1.2 New Query DDB XB-N- Registered Servers Database Engine Object Explorer Connect - 703 E MOMDAD (SQL Server 120.25600 - MOMDADVOwner) Databases System Databases Database Snapshots New Database... New Query Script Databases Tasks Policies Facets Start PowerShell Disk Usage Disk Usage by Top Tables Disk Usage by Table Disk Usage by Partition Backup and Restore Events All Transactions All Blocking Transactions Top Transactions by Age Top Transactions by Blocked Transactions Count Top Transactions by Locks Count Resource Locking Statistics by Objects Object Execution Statistics Database Consistency History Memory Usage By Memory Optimized Objects Index Usage Statistics Index Physical Statistics Schema Changes History User Statistics P2 Sec Ser | Rep Alw Mar Inte SOL Reports Standard Reports Rename Delete Custom Reports Backup and Restore Events Disk Usage Refresh Properties Ready Ago 10:20 PM 1/28/2017 e 35) Expand the "Successful Backup Operations" and "Successful Restore Operations portions. It should look like the below: Backup and Restore Events - 1/28/2017 10:21 PM - MOMDAD - Microsoft SQL Server Management Studio File Edit View Project Debug Tools Window Help BH 2 New Query DEOS Registered Servers Backup and Resto...021 PM - MOMDAD X a Database Engine User Name Recovery Model Dillerertid Rase LSN Successful Backup Operations Duration Start Time minutes) Backup Type Backup Size Backup Name 1/28/2017 Database 9:41:18 PM AdvertureWorks2014-F ME Differential Database Backup 1/28/2017 022 Database 190.08 MB Adventure Works2014 11:07:19 AM Database Backup 7/17/2014 0.07 4:18:18 PM Database Adventure Works2014-ful 000 Device Type Da temporary De temporal Disk terror Mom Dad Owner SIMPLE Mom Dad Owner SIMPLE VCG souley SIMPLE 48000000001600159 49 Not oplicable 48 Not applicable 45 190.08 MB Die Back Backup Operation Errors Show details of the errors, which caused the backup operation failure in the recent post No backup operatione non occured for Adverture Vaka2014 database in the recent part, er delal race a not enabled Object Explorer Connect - 373 MOMDAD (SOIL Server 120.25690 - MOMDADVOwner) Databases System Databases Database Snapshots Adventure Works2014 Azure Test BUCompany henry premiere ReportServer Report Server TempDB sysutility_mw Security Server Objects Replication Always On High Availability Management Integration Services Catalogs SQL Server Agent Success Restore Operatione Date Time Destination Recovery Option User Restore Mode Type Dertil No replace 1/28/2017 10:19:16 PM Adverture Worka2014 Recovery Mon Dad Owner 1/28/2017 10:19:12 PM Adventure Works 2014 Database No replace No recovery MonDad Owner Backup Nene Adverture Works:20 14. Database Backup Adventure Works 20 14-Full Database Backup Adventure Works20 14 Full Database Adventure Works20 14 Full Database 1/28/2017 10:18:47 PM Adventure Worka 2014 Database No replace No recovery MonDad Owner Backup 1/3/2017 1059 45 AM Adventure Worka2014 Database No replace Recovery Mon Dad Owner Ready 10:22 PM 1/28/2017 36) ($$)DELIVERABLE (20 points) Take a screenshot (or two if necessary) showing all of the events in both sections and add it to the word doc below: 37) If working on a lab machine, remember to backup your databases onto the U: drive to restore for your next assignment. Lab machine users will not be able to continue to the extra credit exercise