You are the network administrator supporting SQL Server. The network consists of a single Active Directory domain. All servers run Windows Server. Your database server has a locally attached tape drive. You need to back up all data at least once a week. Every day, you need to back up the data that was changed after the last backup. You need to minimize the amount of data that must be backed up every day. Which backup types should you use?

You are the network administrator supporting SQL Server. The network consists of a single Active Directory domain. All servers run Windows Server. Your database server has a locally attached tape drive. You need to back up all data at least once a week. Every day, you need to back up the data that was changed after the last backup. You need to minimize the amount of data that must be backed up every day. Which backup types should you use?

You are the network administrator supporting SQL Server. The network consists of a single Active Directory domain. All servers run Windows Server. Your database server has a locally attached tape drive. You need to back up all data at least once a week. Every day, you need to back up the data that was changed after the last backup. You need to minimize the amount of data that must be backed up every day. Which backup types should you use?


B – Full
C – Incremental

(Perform a full backup once a week; perform a differential backup daily. This means the restore requires at least two tapes for a complete recovery. Backup and restore is always about which is fastest: a fast backup results in a slow restore. Had you done a full backup each day, your restore would involve only one tape.)