Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

1 of 9

Lab Answer Databases

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

2014

Lab: Restoring Exercise

Task 1: Prepare

1.

Ensure running,

are both ADVENTUREWORKS\Student

with the 2.

In the D:

click Run as

administrator 3.

Click Yes

wait for the

script to

Task 2: Determine

1.

Start SQL

database engine

using Windows 2.

In Object

database is

in a Recovery 3.

In SQL

following

Transact-SQL ALTER

26/09/2016 16:01

Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

2 of 9

4.

Note the

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

online because

the primary 5.

View the

HumanResources.mdf file is

not present.

Task 3: Restore

1.

2.

In SQL HumanResources

Database.

In the Restore

backup history

for the

automatically

selected. 3.

In the Script

4.

When the

5.

View the backup

OK.

that the full backup media

set. 6.

In Object

recovered and

ready to

Result: After

Exercise Backups

database.

Transaction Log

Task 1: Determine

1.

In SQL

note that the

InternetSales

26/09/2016 16:01

Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

3 of 9

2.

Click New

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

to bring the

database ALTER

3.

Note the

primary data file.

4.

View the

mdf file is

present.

unusable.

Task 2: Perform

1.

View the

InternetSales_log.ldf file is

present. 2.

In SQL

following

Transact-SQL USE master; BACKUP WITH 3.

Click Execute

successful.

Task 3: Restore

1.

In SQL

InternetSales

database, 2.

In the Restore

tail-log backup

is listed. 3.

In the Restore

elect

Device

26/09/2016 16:01

Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

4 of 9

4.

In the Select

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

backup File

– MIA-SQL 5.

In the Select

\Backups\InternetSales.bak is

listed, and 6.

In the Locate

\Backups\IS-TailLog.bak

and click 7.

8.

In the Select \InternetSales.

OK.

Note that

and a

transaction copy-only

); and a IS-TailLog.bak). All

of these 9.

On the

WITH

RECOVERY. 10. In the Script 11.

OK.

When the

12. View the

that the full

backup,

restored using

the NORECOVERY

used the

default 13. In Object

and ready to

use.

Result: After

Exercise

Task 1: Begin

26/09/2016 16:01

Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

5 of 9

1.

In SQL

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

verify that the

AWDataWarehouse 2.

Click New the database

restore of AWDataWarehouse_Read-

Write.bak USE master; RESTORE FROM WITH 3.

Click Execute

4.

In Object

successful. verify that

AWDataWarehouse

Task 2: Restore

1.

In SQL following

Online

pane, enter the 2 in the

AWDataWarehouse_Read-Write. RESTORE FROM WITH 2.

Select the

message to

verify that 3.

In Object

verify that

AWDataWarehouse 4.

Expand dbo.FactInternetSales

right-click retrieve data

26/09/2016 16:01

Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

6 of 9

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

from this 5.

In Object 1000 Rows

Select Top stored in the

read-only

Task 3: Restore

1.

In SQL RESTORE

the Transact-SQL under

the existing RESTORE FROM WITH 2.

Select the

message to

verify that 3.

In Object

Select Top

1000 Rows

stored in the

read-only

Result: After

database.

26/09/2016 16:01

Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

7 of 9

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

26/09/2016 16:01

Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

8 of 9

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

26/09/2016 16:01

Lab Answer Key: Module 5: Restoring SQL Server 2014 Databases

9 of 9

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

26/09/2016 16:01