You maintain a SQL Server 2008 Enterprise Edition instance that contains a database
named Finance. You need to reduce the size of the full database backup files of the Finance
database. Which Transact-SQL statement should you use?
A.
BACKUP DATABASE FINANCE TO DISK = •t:\backups\finance.bak*;
B.
BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak’ WITH
COMPRESSION:
C.
BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak’ WITH
DIFFERENTIAL:
D.
BACKUP DATABASE FINANCE TO DISK = ‘t:\backups\finance.bak’ WITH
COMPRESSIONDIFFERENTIAL;