相关考题

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.TheDworksdatabasehastheProductstable.NowyouhavetoreplicatetheProductstabletotheSQLServerinstancesatremotelocations,soyoucreateaMergeReplicationtopologyandaPublicationtodothis.The Publicationhasa21-dayretentionperiod.Thereisauserwhogoesonabusinesstrip,30dayslaterhecomesbackandfindsthatdatainhisdatabaseisnotthelatest.TheWindowsEventlogstatesthefollowingerrormessage:"Replication:expiredsubscriptiondropped."Youmustgetthelatestdataintheuser'sdatabaseandmakesurethatfuturedatachangesareappropriatelyreplicated.Sowhatactionshouldyouperformtoachievethisgoal?()

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDworksintheinstance.YouarelogshippingtheAdventureworksdatabasetoaremoteSQLServer2008instance.TheprimarySQLServerinstancerequiredarestartduringtheweekend.Butyounoticethatlogshippinghasstoppedworkingaftertheweekend.YouhavetochecklogshippingoftheAdventureworksdatabaseandfindouttheproblem.Whatshouldyoudo?()

单项选择题 YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.Ontwocluster-readynodes,youintendtoperformaninstallationofaSQLServer2008mission-criticalcluster.Constantavailabilityisneededbythemission-criticalcluster.YouhavetoconfiguretheSQLServerclustertofailoverandreducetheservicedisruptiontotheleast.Whichfailoveroptionshouldyouuse?()