Earlier in the course, you learned about Services. An often neglected but critical service is running backups. This project serves as a first step towards creating and then automating the backup process in both the Windows and Linux environments. This project requires that you use an existing install of Windows Server from Project 1 and Ubuntu Server from Project 2. You will include a reflective paper of at least 2 pages in current APA format that details the installations, configurations, challenges, and solutions to complete the following systems administration project: In the Windows server environment, you will create two separate scripts within PowerShell that will perform two types of backups of a given source directory and store the backed up files in a given target directory (preferably on a separate drive). The first script will perform a full backup and the second script will perform an incremental backup on the remaining days of the week. Lastly, using the Microsoft Management Console Task Scheduler, you will set up a schedule for the first script (the full backup script) to run on Sundays and Wednesdays and a schedule for the second script (the incremental backup script) to run on the remaining days of the week.Provide three pieces of evidence showing that your scripts were successful: 1) a copy of your scripts; 2) clear screenshots of the Task Scheduler interface showing the correctly scheduled tasks; and 3) results of the backup processes (specifically the files in both the source and target directories).In the Ubuntu environment, you will perform the same tasks as the last two steps. You will create two separate BASH scripts that will perform two types of backups of a given source directory and store the backed up files in a given target directory (preferably on a separate drive). The first script will perform a full backup and the second script will perform an incremental backup on the remaining days of the week. For assistance with this, Google “incremental backup script in bash” for starters. Once you have these scripts working, use the cron command to schedule the scripts. As the previous steps dictate, you will set up a schedule for the first script (the full backup script) to run on Sundays and Wednesdays and a schedule for the second script (the incremental backup script) to run on the remaining days of the week.Provide three pieces of evidence showing that your scripts were successful: 1) a copy of your scripts; 2) clear screenshots of the scheduled scripts using crontab or the contents of the /etc/cron.* directories showing the correctly scheduled tasks; and 3) results of the backup processes (specifically the files in both the source and target directories). The paper must use appendixes to reference screenshots along the way. Screenshots must identify a unique piece of information on the user’s computer such as a picture and include the system date and time in each screen capture. At the minimum, screenshots must exist during the initial setup of VirtualBox, installation of the operating system, configuration of the user accounts, security updates, and firewall configuration of the new operating systems. Subsequent screenshots must exist that detail the other deliverables in each phase (e.g., such as DNS).

1) Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in the metadata of Project 2. You may need to use a combination of DROP TABLE, CREATE TABLE, and ALTER TABLE SQL statements. Make sure that entity and referential integrity are enforced by declaring a primary key for each table (these may be composite keys) and declaring all appropriate foreign keys. Your CREATE TABLE and ALTER TABLE statements (if desired) must show integrity constraints, as appropriate, for NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, REFERENCES, and CHECK constraints. Be sure to save your SQL script file used to create these tables with a .sql extension and your output SPOOL file with a .lst or .txt extension. You should rerun and test your SQL script file until it runs without any errors (this is why you’ll want to include DROP TABLE statements). Submit your SPOOL file showing that all SQL in your SQL script file worked properly. 2) Populate each of your tables with at least five valid rows of data each and show the SQL INSERT statements as you executed them. Populate other tables in your database, as necessary, to satisfy referential integrity. Save your SQL script file and SPOOL file with the correct extensions. You should test and rerun your SQL script file until it runs without any errors. Submit your SPOOL file showing that all SQL in your SQL script file worked properly. 3) Develop an SQL script file to perform the following queries and updates. You should test your SQL script file until it runs without any errors.

Using the "classicmodels" database you installed in Module 1, list the customers who have not placed any orders. Sort your results by customer number.Modify your query to list customers who have placed fewer than five orders.Submit your query and query results in a Word file.