You are the systems administrator for your company. The network consists of a Windows Essential Business Server 2008 Premium Edition environment. The database server is named SQL1. SQL1 contains a database named ProdDB, which in turn contains three filegroups.
You are in the process of configuring the backup process for ProdDB. You want to be able to perform an online restoration of ProdDB in the event any file or filegroup in the database becomes corrupt.
Which types of backup can you use for this purpose? (Choose all that apply.)
A.
Full backups
B.
Differential backups
C.
Copy-only backups
D.
Transaction log backups
E.
Snapshot backups
F.
Incremental backups
Explanation:
You can use full backups, differential backups, and transaction log backups to perform an online restore. An online restore occurs when you restore data while the database is online. If the primary filegroup of a database is online, the entire database is considered to be online, even if one or more of its secondary filegroups are offline. To perform an online restore, you must first restore the data by using appropriate full or differential backups, and then restore the log by using the WITH RECOVERY clause for the last log restore. This brings the restored data online.You cannot use copy-only backups to perform an online restore. 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 snapshot backups to perform an online restore because SQL Server does not support an online restore from a snapshot backup. A snapshot is a read-only copy of a database at a specific point in time. Any change made to the database after this point in time is not available in the snapshot. A snapshot is always placed in the SQL Server instance on which the SQL Server database resides.
You cannot use incremental backups to perform an online restore because incremental backups are not supported by SQL Server 2008.