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)