Lab Answer Key: Module 14: Appendix A - Troubleshooting Common

Sep 26, 2016 - Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo... https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book.
2MB taille 0 téléchargements 279 vues
Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo...

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Lab Answer Troubleshooting Lab: Troubleshooting Exercise

Task 1: Read

• Read the scenario

Task 2: Troubleshoot

1.

In Object

expand Logins.

2.

Beside

login is

disabled. 3.

Right-click

4.

In the Select

5.

In Object

login is now

enabled.

Result: After

issue.

Exercise

Task 1: Read

1 of 8

26/09/2016 16:06

Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo...

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

• Read the supporting

Task 2: Troubleshoot

1.

In Object of the AdminDB

note the status DBA may

have performed 2.

In Object

Restore, and

click Transaction 3.

In the Restore

backups of

database 4.

In the Microsoft

5.

In Object

database is

now available.

Result: After

Exercise

issue.

Issue

Task 1: Read

• Read the exercise

Task 2: Troubleshoot

1.

In Object

Agent, and

expand 2.

2 of 8

Right-click

26/09/2016 16:06

Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo...

3.

In the Start

4.

In Object

5.

In the Log

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

History. failing row to

expand 6.

Click on

7.

In the Selected

8.

In the Log

9.

In Object ThomasQ

10. In the Credential

Password textbox,

and the 11.

In Object

Step.

12. In the Start

click Close.

Result: After

execution issue.

Exercise

Task 1: Read

• Read the exercise

Task 2: Troubleshoot

1.

In Object

right-click

AdminDB

3 of 8

26/09/2016 16:06

Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo...

2.

In the Select

3.

Review

4.

Change

5.

Change

Note: waiting

6.

In Object

7.

In the Query

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

rather than

EXEC

8.

On the

Result: After

Exercise

performance issue.

Issue

Task 1: Read

• Read the exercise

Task 2: Troubleshoot

a.

In

right-click

CityDetails

4 of 8

26/09/2016 16:06

Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo...

b.

In

c.

Review

d.

Change

Result: After

5 of 8

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

connection issue.

26/09/2016 16:06

Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo...

6 of 8

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:06

Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo...

7 of 8

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:06

Lab Answer Key: Module 14: Appendix A - Troubleshooting Commo...

8 of 8

https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

26/09/2016 16:06