Part 2 SQL database

TSql scripts.

Backup and Restore 1. Create a full database backup for the database in the following backup sets C:\Backups\ [file_name].bak". a. Insert some data into the database and perform a differential backup in the same backup sets. b. Insert some data into the database and perform a transaction-log backup in the same backup sets. c. Change the Backup database option to be compressed to reduce the size and time taken to recover the database. 2. You want to automate your backup overhead by scheduling your backups in the following structure: a. Weekly Full-Backup b. Daily Differential Backup c. Hourly Transaction-log backup. 3. Write in details the necessary steps to restore the database in case of failure. Security The two users [user 1] and [user 2] are hired to manage the data of the first schema [Schema 1]. They can insert, update and delete data of [Schema 1]. The user [user 3] that can only insert and update data of [Schema 1] but is denied to delete 1 any data. The user [user 4] can only perform select queries on both schemas tables. Create the necessary roles that facilitate the database security management in addition to the users (user 1], [user 2], [user 3] and [user 4]. Note: You should rename the [user 1], [user 2], [user 3] and [user 4]