CS409 Assignment 3 Solution and Discussion

[zareen]

Assignment No. 03 

SEMESTER Fall 2019
CS409- Database Administration
Total Marks: 20

Due Date: 21/01/2020

Instructions
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:

1. The assignment is submitted after the due date.

2. The submitted assignment does not open or the file is corrupt.

3. The assignment is fully or partially copied from (other student or ditto copy from the handouts or internet).

4. Student ID is not mentioned in the assignment File or name of file is other than the student ID.

5. The assignment is not submitted in .doc/docx format.
   Uploading instructions
   Your submission must include:

6. Assignment should be in .doc/docx format.

7. Save your assignment with your ID (e.g bx020200786.doc/docx).
   Assignment submission through email is NOT acceptable
   Objective
   The objective of this assignment is
   To give some important knowledge about the database environment of organization

Lectures Covered: This assignment covers Lecture # 08 – 11

Deadline

Your assignment must be uploaded/submitted on or before 21/1/2020.

Question # 01:

Suppose you have the database titles as “SchoolManagement” and you are asked to create its backup. Write down all steps of creating full backup using Microsoft Management Studio and write T-SQL query of creating backup code also.

For any query about the assignment, contact at [email protected]
Good Luck