70-450 · Question #36
You are a professional level SQL Sever 2008 Database Administrator. A large database is hosted by the instance. The company utilizes the following backup strategy for the database: - First, the…
The correct answer is D. To finish the task, COPY_ONLY should be utilized. COPY_ONLY is a backup option which will not affect the normal backup sequence. NONIT specifies that the backup should be appended to an existing set. SKIP works in conjunction with INIT/NONIT and skips the check for media name and expiration. MIRROR to will make a secondary…
Question
You are a professional level SQL Sever 2008 Database Administrator. A large database is hosted by the instance. The company utilizes the following backup strategy for the database:
- First, the performance of full database backups is implemented
weekly.
- Secondly, the performance of differential backups is implemented
daily.
- Thirdly, the performance of transaction log backups is implemented
hourly. According to the restoring plan, an unscheduled full backup should be performed. A full database backup should be performed, and the scheduled backup strategy should not be interrupted. Form the following four options, which one should be utilized to finish the task?
Options
- ATo finish the task, SKIP should be utilized.
- BTo finish the task, NOINIT should be utilized.
- CTo finish the task, MIRROR TO should be utilized.
- DTo finish the task, COPY_ONLY should be utilized.
How the community answered
(29 responses)- A3% (1)
- B3% (1)
- C14% (4)
- D79% (23)
Explanation
COPY_ONLY is a backup option which will not affect the normal backup sequence. NONIT specifies that the backup should be appended to an existing set. SKIP works in conjunction with INIT/NONIT and skips the check for media name and expiration. MIRROR to will make a secondary copy of the backup. --------------------------------------------------------------------------------- A copy-only backup is a SOL Server backup that is independent of the sequence of conventional SQL Server ba@ups. Usually, taking a backup changes the database and affects how later backups are restored, However, occasionally, it is useful to take a backup for a special purpose without affecting the overall backup and restore procedures for the database. For this purpose, copy-only backups were introduced SQL Server 2005. The types of copy-only backups are as follows: Copy-only full backups {all recovery models) A copy-only full backup cannot serve as a differential base or differential backup and does not affect the differential base. Copy-only log backups {full recovery model and bulk-logged recovery model only) A copy-only log backup preserves the existing log archive point and, therefore, does not affect the sequencing of regular log backups. Copy-only log backups are typically unnecessary. Instead, you can create another routine, current log backup (using WITH NORECOVERY), and then use that backup together with all other previous log backups that are required for the restore sequence. However, a copy-only log backup can be created for performing an online restore. The transaction log is never truncated after a copy-only backup. Copy-only backups are recorded in the is_copy_only column of the backupset table.
Topics
Community Discussion
No community discussion yet for this question.