Self-check 2
Part-I multiple choice
1. Backing up the data to a server which is geographically separated from a production
systems.
A. Online B. Offline C. Offsite D. Onsite
2. A mix of offsite and onsite storage approaches for the benefit of completeness.
A. Dynamic B. Hybrid C. Cloud D. Cold
3. One is not the advantages of onsite backup
A. May be destroyed during a catastrophic event C. Control of your own data
security
B. Immediate access to data D. Less expensive
4. Which RAID level is called a mirroring of data?
[Link] 0 B. RAID 1 C. RAID 2 D. RAID 7 E. All level
5. How many disk drives are required to implement disk mirroring?
A. At least two physical drives.
B. At least one disk drive and two logical drives
C. At least two logical drives
D. None
6. Which one of the following statement is incorrect about RAID?
B. It contains a set of physical disk drives.
C. The operating system views these separate disks as a single logical disk.
D. Data is distributed across the physical drives of the array.
E. None
Part-II Give short answer
1. List and explain Types of backup?
2. Write the difference between hot and cold backup?
3. List the Advantages and Dis advantages of Full backup
Operation sheet 2.1 Take backup
Operation title: Take backup
Purpose: Take database Backup Using SSMS
Tools and equipment: SQL server installed computer
Steps by doing tasks:
1. Open SQL Server 2008
2. Connect the Server and point to your database
3. Make right click on your database and Select
Task click on Backup
4. Select the backup destination and write the backup name(Add)
5. Click on OK button
6. Click on OK button
Operation sheet 2.2 Taking Database Offline
Operation title: Taking Database Offline
Purpose: Taking Database Offline using SSMS (SQL Server Management Studio) and T-
SQL
Tools and Equipment: computer and SQL server
Steps by doing tasks:
1. Login to SQL Server Management Studio.
2. In the Object Explorer, select the database you want to take offline and right-click.
3. In the right-click menu go to Tasks >> Take Offline.
4. In the pop-up window, choose the check box under the Drop All Active
Connections and click OK
5. After Opening SQL Server Management Studio and open a Query Editor pane.
Enter and execute the following code:
USE DB_name;
GO
ALTER DATABASE <<Database-name>> SET OFFLINE
Operation sheet 2.3 Take Full backup
Operation title: Take Full backup
Purpose: Back Up the Database Using T-SQL
Tools And Equipment: computer and SQL server
Steps by doing tasks:
1. After Opening SQL Server Management Studio and open a Query Editor pane. Enter and
execute the following code:
BACKUP DATABASE << databaseName >> TO DISK = 'C:\[Link]'
The command is BACKUP DATABASE databaseName. The "TO DISK" option specifies that the
backup should be written to disk and the location and filename to create the backup is specified.
2. Create a full SQL Server backup with a password
BACKUP DATABASE << databaseName >>
TO DISK = 'C:\ [Link]'
WITH PASSWORD = 'Q!W@E#R$'
GO
LAP Tests
Instructions: Given necessary templates, tools and materials you are required to perform
the following tasks accordingly.
Task 1: To do the following tasks use database Backup Using SSMS and T-SQL
Task2: Create a database named TVET.
Task 3: Create a folder named “Data” on the desktop and take the backup of your database
in Data folder using “SSMSbackup” and “TSQLbackup” as a backup name using both SSMS
and T-SQL respectively.
Task 4: Create a mirrored SQL Server backup
Task 5: Create a full SQL Server backup with progress stats
Self-check 3
Part-I multiple choice
1. _______________the process of restoring the database to the consistent state in the
event of a failure.
A. Restore B. Attach C. Recovery D. All
2. A process by which DBMS REDO the transactions that successfully complete before
failure but did not write to the physical disk.
B. Recover B. Roll Forward C. Rollback D. Restore
3. A recovery method by which the modified version of a data item is written at a separate
disk location.
A. Differed Update
B. Shadow update
C. Immediate update
D. None
4. Factors that enforce the transaction not to reach a commit or abort point.
A. Human error
B. operating system crash
C. DBMS crash
D. All
Part-II Give short Answer
1. Write and explain recovery approaches
2. Explain Rollback and commit
Operation sheet 3.1
Operation title: Restoring Database from the backup
Purpose: Restore Database from the backup
Material: computer and SQL server
Steps
1. Open SQL Server 2008
2. Select the Master database
3. Make right click your database (VV)
4. Point on TasksRestoreclick on Database
5. Specify the location of your backup
6. Select the recovery state
7. Click OK button
LAP Test
Instructions: Given necessary templates, tools and materials you are required to perform the
Task 1: backup Database using T-SQL?
Task 2 Restoring Database from the backup by using T-SQL?
