Manually perform a full backup of your Project database to C:$\backslash$Project$\backslash$Project$.$bak.

$20.$

Ensure that full backups of the Project database are performed every day at $10$:$00$pm using a maintenance plan. Execute your maintenance plan to ensure that it works. Finally, right$-$click your maintenance plan and choose Modify to view a flowchart of its configuration. Take a screenshot of that configuration and save it as C:$\backslash$Project$\backslash 7.$png$.$

$21.$

Create a SQL Query file that can quickly be executed to restore the previous night$$s backup $($without losing any transactions since the previous night$$s backup!$).$ Perform a sample restore using this query to make sure it works. Finally, save the query to C:$\backslash$Project$\backslash 8.$sql$.$

$22.$

Ensure that the Project database is automatically checked for errors and then shrunk every Monday and Thursday at $2$:$00$am using a single maintenance plan. Execute your maintenance plan to ensure that it works. Finally, right$-$click your maintenance plan and choose Modify to view a flowchart of its configuration. Take a screenshot of that configuration and save it as C:$\backslash$Project$\backslash 9.$png$.$

SQL$16$A $$ Final Project: Administering SQL Server $2019$

$23.$

Check your database for errors. Perform a sample repair in single user mode and return to multiuser mode when finished. Save the commands you performed in a file called C:$\backslash$Project$\backslash 10.$sql$.$

$24.$

Configure the Performance Data Warehouse to monitor the key areas of your SQL server $($this data should be stored in a database called PDW$).$ After a period of time $($e$.$g$.1$ day$),$ generate the three reports $($Disk Usage, Server Activity, Query Statistics$).$ Right$-$click each report and choose Export $>$ PDF and save it to C:$\backslash$Project$\backslash$ using the default filename. You should have $3$ reports in this folder:

C:$\backslash$Project$\backslash$Disk Usage Summary.pdf

C:$\backslash$Project$\backslash$Query Statistics History.pdf

C:$\backslash$Project$\backslash$Server Activity History.pdf

$25.$

Enable your system as a publisher and distributor $($use the default database name of distribution for your distributor database$).$ Next, configure snapshot replication to back up the Employee table in the Project database to a new database you create called Project$2.$ Although Project$2$ would normally be on another SQL server, you will create Project$2$ on your own SQL server instance.

$26.$

Open a new query in SSMS$.$ Right$-$click the white background of the query window and click Results To $>$ Results to File. Next, execute the following queries in this window. When prompted to save the results to a file, choose C:$\backslash$Project$\backslash 11.$rpt$.$

USE distribution

GO

EXEC sp$\_$replmonitorhelppublication