Which backup option should you use?

You administer a SQL Server 2008 instance that hosts a large database. The database has
the following backup strategy: Full database backups are performed weekly. Differential
backups are performed daily. Transaction log backups are performed hourly. The recovery
plan requires you to perform an unscheduled full backup. You need to perform a full
database backup without interrupting the scheduled backup strategy. Which backup option
should you use?

You administer a SQL Server 2008 instance that hosts a large database. The database has
the following backup strategy: Full database backups are performed weekly. Differential
backups are performed daily. Transaction log backups are performed hourly. The recovery
plan requires you to perform an unscheduled full backup. You need to perform a full
database backup without interrupting the scheduled backup strategy. Which backup option
should you use?

A.
SKIP

B.
NOINIT

C.
MIRROR TO

D.
COPY_ONLY



Leave a Reply 0

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