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? （） A.You should restore the full backup B.You should restore the database snapshot from 16:30 hours. C.You should restore the database snapshot from 17:30 hours D.You should restore both the full backup and the differential backup.

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 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? （）

A.You should restore the full backup
B.You should restore the database snapshot from 16:30 hours.
C.You should restore the database snapshot from 17:30 hours
D.You should restore both the full backup and the differential backup.

相关考题

单项选择题 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?（）

单项选择题 YouworkinacompanywhichusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.Youputforwardadatabasemaintenanceplan.Themaintenanceplanrebuildsindexes,checksdatabaseintegrity,writesareporttoatextfile.Nowthecompanyrequiresthatwhenthemaintenanceplanexecutesabnormally,theoperatorscanbenotifiedbyane-mailmessage.You'vebeenassignedthistask.SoyouhavetomakemodificationsontheSQLServerinstance.Whatshouldyoudo?（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064