Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
1 of 14
Lab Answer Backup
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Implementing a
Lab: Backing Exercise
Task 1: Prepare
1.
Ensure
are both
running, ADVENTUREWORKS\Student 2.
In the D:
click Run as
administrator 3.
Click Yes
wait for the
script to
Task 2: Set
1.
Start SQL
database engine
using Windows 2.
In Object
and click
Properties 3.
In the Database
Options page, in
the Recovery
Task 3: Perform
1.
In SQL
right-click 26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
2 of 14
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
HumanResources 2.
In the Backup
Backup type
is set to
and click
Remove
box, enter the
file name 3.
In the Backup page, select
Options sets. Then
enter the 4.
In the Backup page, note
Backup Options list, select
Compress 5.
When the
6.
Verify that
\Backups
folder,
Task 4: Modify
1.
In SQL
2.
Enter the Alternatively,
Execute. \Labfiles
\Lab04\Starter UPDATE SET PhoneNumber='151-555-1234' WHERE 3.
Note the
saving the file.
Task 5: Perform
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
3 of 14
1.
In SQL
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
right-click
HumanResources 2.
In the Backup
Backup type
is set to \HumanResources. 3.
In the Backup page, ensure
Options existing
backup 4.
In the Backup
Backup Options
page, change
Backup 2. Then in
the Set 5.
When the
6.
View the
verify that its
size has
Task 6: View
1.
In SQL HumanResources
right-click Backup
and Restore 2.
In the Backup Backup
Successful performed for this
database. 3.
In the Device
to view
details 4.
Close the
Result: At to R:\Backups\HumanResources.
HumanResources database
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
4 of 14
Exercise Backups
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Transaction Log
Task 1: Set
1.
In SQL
Then
right-click 2.
In the Database
page, in the
Recovery
OK.
Task 2: Perform
1.
In Object
Tasks, and
click Back 2.
In the Backup
Backup type is set
to Full
Remove.
Then click
file name
R:\Backups\InternetSales. 3.
In the Backup select Back
Options page, Then enter the
new media 4.
In the Backup
Options page,
note the
select
Compress 5.
When the
6.
Verify that
\Backups folder,
and note
Task 3: Modify
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
5 of 14
1.
In SQL
2.
Enter the Alternatively,
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Execute. \Labfiles\Lab04
\Starter UPDATE SET ListPrice WHERE 3.
Note the
again in a later
task.
Task 4: Perform
1.
In Object
Tasks, and
click Back 2.
In the Backup
type list, select
Transaction \InternetSales 3.
In the Backup ensure
Options page, backup set
are selected. 4.
In the Backup change
Options page, in the Set
backup 5.
When the
6.
View the
verify that its size
has increased.
Task 5: Modify
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
6 of 14
1.
Modify Alternatively,
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Execute. \Labfiles\Lab04
\Starter UPDATE SET ListPrice WHERE 2.
Note the
again in a later
task.
Task 6: Perform
1.
In Object
Tasks, and
click Back 2.
In the Backup Differential
type list, select \Backups\InternetSales.bak
is listed. 3.
In the Backup ensure
Options page, backup set
are selected. 4.
In the Backup
Options page,
change
the Set
backup 5.
When the
6.
View the
verify that its size
has increased
Task 7: Modify
1.
Modify
Execute.
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
7 of 14
Alternatively,
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
\Labfiles\Lab04
\Starter UPDATE SET ListPrice WHERE 2.
Note the
saving the file.
Task 8: Perform
1.
In Object
Tasks, and
click Back 2.
In the Backup
type list, select
Transaction \InternetSales. 3.
In the Backup ensure
Options page, backup set
are selected. 4.
In the Backup change
Options page, Then in the Set
backup 5.
When the
6.
View the
verify that its size
has increased.
Task 9: Verify
1.
In SQL
2.
Enter the
Execute.
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
8 of 14
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
RESTORE FROM GO 3.
Verify that
4.
Modify RESTORE FROM GO
5.
Note the
6.
Modify RESTORE FROM GO
7.
Verify that
Result: At R:\Backups\InternetSales.
the file.
database to
Exercise
Task 1: Set
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
9 of 14
1.
In SQL
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Then
right-click 2.
In the Database
Options page, in
the Recovery
Task 2: Back
1.
In SQL
2.
Enter the
Execute.
BACKUP FILEGROUP TO DISK WITH 3.
Verify that
COMPRESSION; created in the
R:\Backups
Task 3: Perform
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
10 of 14
1.
In SQL
2.
Enter the
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Execute.
BACKUP READ_WRITE_FILEGROUPS TO DISK WITH 3.
Verify that
COMPRESSION; created in
the R:\Backups
Task 4: Modify
1.
In SQL
2.
Enter the Alternatively,
Execute. D:\Labfiles
\Lab04\Starter INSERT VALUES (1, 20080801, 3.
Note the
saving the file.
Task 5: Perform
1.
In SQL
2.
Enter the
Execute.
BACKUP DATABASE
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
11 of 14
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
READ_WRITE_FILEGROUPS
TO DISK = 'R:
WITH DIFFERENTIAL,
'AWDataWarehouse-Active Data
Diff', COMPRESSION;
Task 6: Verify
1.
In SQL
2.
Enter the
Execute.
RESTORE FROM GO 3.
View the BackupTypeDescription
4.
Modify RESTORE FROM GO
5.
View the BackupTypeDescription
6.
Close SQL
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
12 of 14
Result: At AWDataWarehouse backed up the \AWDataWarehouse_Read-Write.
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
filegroup in the you will have
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
13 of 14
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
26/09/2016 16:00
Lab Answer Key: Module 4: Planning and Implementing a Backup Str...
14 of 14
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
26/09/2016 16:00
