What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The backup of CK_Prod is as follows:
* Full backup at 01:00 daily
* Transaction log backup every 20 minutes
* Differential backup every 5 hours

However, you need to do a full backup of CK_Prod at 12:00. You need to make sure that the
backup would not affect the overall backup and restore procedures for CK_Prod and that you can
restore the Backup files in correct sequence.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The backup of CK_Prod is as follows:
* Full backup at 01:00 daily
* Transaction log backup every 20 minutes
* Differential backup every 5 hours

However, you need to do a full backup of CK_Prod at 12:00. You need to make sure that the
backup would not affect the overall backup and restore procedures for CK_Prod and that you can
restore the Backup files in correct sequence.

What should you do?

A.
You should consider using the following:
bak’ WITH COPY_ONLY;

B.
You should consider using the following:
bak ‘ WITH NOUNLOAD;

C.
You should consider using the following:
trn’ WITH DIFFERENTIAL;

D.
You should consider using the following:
trn’ WITH COPY_ONLY;

E.
You should consider using the following:
trn ‘ WITH NOUNLOAD;

F.
You should consider using the following:
bak’ WITH DIFFERENTIAL;

Explanation:
By using copy_only you do not affect the backup sequence.

Incorrect answer:
trn ‘ WITH DIFFERENTIAL;
by doing this you already affected your backup sequence and you are only backing up the
transaction log.

Part 2, Restore databases. (8 questions)



Leave a Reply 0

Your email address will not be published. Required fields are marked *