DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. During the night a daily full backup of
ABC_Prod is started at 03:15, a differential backup is performed every 90 days minutes and a
transaction log backup is performed every 20 minutes.
This particular day your CEO has requested that you make an extra full backup during the lunch
break starting at 11.30. How can you meet her request while keeping the database backup files in
order for future backups and restores?
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.