YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.TransactionlogshippingoccursfromSQ
L1toSQL2byusingdefaultSQLServerAgentschedulesettings.YouneedtoreconfiguretransactionlogshippingtoprovideminimumlatencyonSQL2.Whatshouldyoudo?()
A.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccurseveryminute.OnSQL2,maintaindefaultschedulesettingsforboththelogshippingcopyandtherestorejobs.
B.OnSQL1,changethescheduletypeforthetransactionlogbackuptoStartautomaticallywhenSQLServerAgentstarts.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgentstarts.
C.OnSQL1,maintaindefaultschedulesettingsforthetransactionlogbackupjob.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgentstarts.
D.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccurseveryminute.OnSQL2,rescheduleboththelogshippingcopyandtherestorejobssothattheyoccureveryminute.