Lab Answer Key: Module 11: Performing Ongoing Database Maintenance https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Lab Answer Database Lab: Performing

Maintenance

Exercise

Task 1: Prepare

1.

Ensure running,

are both ADVENTUREWORKS\Student

with the 2.

In the D:

then click

Run as 3.

Click Yes

file, and wait

for the

Task 2: Check

1.

Start SQL

database engine

instance 2.

Open the

3.

Select the

folder. Execute. This

checks 4.

Select the

Execute. This

checks 5.

Select the checks in the dbo.

1 of 8

. This consistency errors minimum 26/09/2016 16:04

Lab Answer Key: Module 11: Performing Ongoing Database Maintenance https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

repair level

Task 3: Repair

1.

In SQL under the

select the code the

InternetSales 2.

Select the Execute

and click structure is now

consistent.

Result: After check database

command to

Exercise

Task 1: View

1.

In SQL

script file in the

D:\Labfiles\Lab11\Solution 2.

Select the

3.

In the results,

Execute.

avg_fragmentation_in_percent

Task 2: Defragment

1.

In SQL code under

select the rebuilds the

indexes

2 of 8

26/09/2016 16:04

Lab Answer Key: Module 11: Performing Ongoing Database Maintenance https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

2.

Select the

3.

In the results,

Execute.

avg_fragmentation_in_percent

Result: After

Exercise

Task 1: Create

1.

In Object

Maintenance

Plans, 2.

In the Maintenance

3.

In the Select

HumanResources

Maintenance 4.

In the New drop down

the Occurs to 6:00 PM,

and click 5.

In the Select

Maintenance

Tasks page,

6.

3 of 8

o

Check

o

Reorganize

o

Update

o

Back

On the

26/09/2016 16:04

Lab Answer Key: Module 11: Performing Ongoing Database Maintenance https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

7.

On the

HumanResources

database 8.

On the

database and

click OK 9.

On the

database and

click OK 10. On the database for every 11.

On the selected,

12. On the

HumanResources backup file click Next. file is Next. has

completed,

Task 2: Run

4 of 8

26/09/2016 16:04

Lab Answer Key: Module 11: Performing Ongoing Database Maintenance https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

1.

In Object

HumanResources

Maintenance 2.

Wait a Maintenance

HumanResources

Maintenance 3.

In the Log

the Daily

Maintenance 4.

Keep clicking

completed.

Then click 5.

In the D: Maintenance_Subplan_1_

6.

In the R:

database has

been created.

Result: After plan.

5 of 8

maintenance

26/09/2016 16:04

Lab Answer Key: Module 11: Performing Ongoing Database Maintenance https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

6 of 8

26/09/2016 16:04

Lab Answer Key: Module 11: Performing Ongoing Database Maintenance https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

7 of 8

26/09/2016 16:04

Lab Answer Key: Module 11: Performing Ongoing Database Maintenance https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

8 of 8

26/09/2016 16:04