You install Windows Essential Business Server 2008 Premium Edition on your company’s network. The network contains a database server named EBS4 that runs SQL Server 2008.
You configure a database named CorpDB on EBS4. You want to back up files in the primary filegroup of the CorpDB database.
What types of backup can you use for this purpose? (Choose all that apply.)
A.
Full backup
B.
Differential backup
C.
Incremental backup
D.
Copy-only backup
E.
Tail-log backup
Explanation:
You can use a full backup, a differential backup, or a copy-only backup to back up files in the primary filegroup of a database. SQL Server 2008 allows you to back up a full database, a partial database, or a set of files and filegroups. SQL Server supports full backups or differential backups for each of these. A full backup contains all the data in a specific database or set of filegroups or files along with the transaction log that is necessary for recovering that data. A differential backup contains only the data that has changed since the latest full backup. In addition, you can use copy-only backups, which are independent of regular SQL Server backups. A copy-only backup is a type of backup that does not affect the overall backup and restore procedures for the database as other conventional SQL server backups do.You cannot use an incremental backup for backing up databases, files, or filegroups in SQL Server 2008 because SQL Server supports only full backups or differential backups.
You cannot use a tail-log backup for backing up files in the primary filegroup of a database. A tail-log backup is the backup of the active transaction log that was not included in the most recent transaction log backup. Tail-log backups are required to restore a database to the point of failure.