Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

Lab Answer Management

Server 2014

Lab: Automating 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: Create

1.

Start SQL

database engine

instance 2.

In Object

existing jobs.

Then right-click 3.

In the New

Backup

HumanResources 4.

In the New

5.

In the New Up Database

1 of 9

box, type Back in the Type

26/09/2016 16:05

Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

drop-down

and in the

Command BACKUP \HumanResources.

6.

In the New

box, type

D:\Lab 7.

In the New

8.

In the New Copy Backup Type drop-down

box, type selected in the command, which

copies Copy

\Labfiles\Lab12\Starter

\HumanResources.

9.

In the New

10. In the New Up Database 11.

In the New

set to 1:Back in the job. the Jobs folder

in Object

Task 3: Test

1.

In SQL

Backup

HumanResources 2.

2 of 9

In the Start

Database) is

selected,

click Close.

26/09/2016 16:05

Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

3.

In Object

View

History 4.

In the Log

most recent

instance 5.

View the text file

contains a HumanResources.bak.

Task 4: Generate

1.

In Object as, point

Script Job generates the

Transact-SQL 2.

Save the

the

D:\Labfiles\Lab12\Starter

Result: After HumanResources.

Exercise

Task 1: Add

1.

Right-click

Navigation

properties 2.

In the Notification System

3.

Click OK

Then, in the and click OK. again to close the

Taskbar 4.

3 of 9

Note the

location.

26/09/2016 16:05

Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

5.

In SQL

Backup

HumanResources 6.

In the Job

Schedules page,

click New 7.

In the New

; in the

Frequency

Once option is

selected;

shown in the

clock in 8.

In the Job

Then wait

until the

Task 2: Verify

1.

In Object

of the

Backup 2.

If the job

3.

Verify that is the time

Last Run time Activity

Monitor

Result: After HumanResources

Exercise

Task 1: Create

1.

In SQL

expand

Security

4 of 9

26/09/2016 16:05

Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

2.

In the New

o

Credential

o

Identity

o

Password

o

Confirm

Task 2: Create

1.

In Object

2.

Right-click

3.

In the New and in the

FileAgent_Proxy, that only the

Operating

Task 3: Configure

1.

In Object

double-click the

Backup 2.

In the Job

Steps page, click

step 1 ( 3.

In the Job

Advanced page, in

the Run 4.

In the Select select [Backup_User]

dialog box, dialog box and

the Job 5.

In the Job

Steps page, click

step 2 (

5 of 9

26/09/2016 16:05

Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

6.

In the Job

drop-down list,

select FileAgent 7.

In the Job

Task 4: Test

1.

Right-click Start Job

2.

Start.

When the

Result: After Backup HumanResources have also created FileAgent_Proxy job.

6 of 9

. Then in the

step of the should HumanResources

26/09/2016 16:05

Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

7 of 9

26/09/2016 16:05

Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

8 of 9

26/09/2016 16:05

Lab Answer Key: Module 12: Automating SQL Server 2014 Management https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...

9 of 9

26/09/2016 16:05