You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1. In the options below, which Transact-SQL statement should you use? （） A.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak'; B.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION; C.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL; D.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION,DIFFERENTIAL;

MCTS(70-432)

单项选择题

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1.
In the options below, which Transact-SQL statement should you use? （）

A.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak';
B.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION;
C.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL;
D.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION,DIFFERENTIAL;

相关考题

单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least. So what action should you perform to achieve this goal? （）

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.Atpresentabout90GBofdataisstoredinDB1.Youmadesomeroughcalculationsthateverydayabout1GBofdataismodifiedorinserted.YousettherecoverymodelofDB1toSimple.Accordingtothecompanyrequirements,duringbusinesshours,datalossofmorethan120minutesworthoftransactionsisunacceptable.Youhavetochooseabackupstrategywhichmustcomplywiththefollowingtworequirements:UsingaslittlediskspaceaspossibleComplyingwiththecompanyrequirements.Sowhatactionshouldyouperformtoachievethisgoal?（）

单项选择题 YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.YouhavesettherecoverymodelofDB1toFull.Youdeployanewprocess.Theprocessmodifies10,000recordsfromtheAccountstableat18:00everyday.Anymodificationmadebytheprocesstothedatamustberevertedanddatabasekeepsonline.Youmustmakesureofthis.Sowhichstrategyshouldyouimplement?（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064