单项选择题
YouworkinacompanywhichusesSQLServer2008.YouaretheadministratorofthecompanydatabasE.NowyouareinchargeofaSQLServer2008EnterpriseEditioninstancE.ThereisadatabasenamedDB1intheinstancE.AbackupofDB1isperformedeveryday.YouhavetominimizethesizeofthefulldatabasebackupfilesofDB1.Intheoptionsbelow,whichTransact-SQLstatementshouldyouuse?()
A.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak';
B.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHCOMPRESSION;
C.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHDIFFERENTIAL;
D.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHCOMPRESSION,DIFFERENTIAL;
A.YouaretheadministratorofthecompanydatabasE.NowyouareinchargeofaSQLServer2008EnterpriseEditioninstancE.ThereisadatabasenamedDB1intheinstancE.AbackupofDB1isperformedeveryday.YouhavetominimizethesizeofthefulldatabasebackupfilesofDB1.Intheoptionsbelow,whichTransact-SQLstatementshouldyouuse?()
A.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak';
B.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHCOMPRESSION;
C.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHDIFFERENTIAL;
D.BACKUPDATABASEDB1TODISK='t:/backups/db1.bak'WITHCOMPRESSION,DIFFERENTIAL;