Part 3 Sql databse TSql scripts

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 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]