您维护一个SQL Server2008 Enterprise Edition实例,该实例包含名为FINANCE的数据库。您需要减小Finance数据库的完整数据库备份文件的大小。您需要使用哪一个Transact—SQL语句?
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 COMPRESSION,DIFFRENTIAL;
正确答案是B