单项选择题
Your company has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need toreconfigure transaction log shipping to provide minimum latency on SQL2. What should you do?（）
A. On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, maintain default schedule settings for both the log shipping copy and the restore jobs.
B. On SQL1, change the schedule type for the transaction log backup to Start automatically when SQL Server Agent starts. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.
C. On SQL1, maintain default schedule settings for the transaction log backup job. On SQL2, change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server Agent starts.
D. On SQL1, reschedule the transaction log backup job so that it occurs every minute. On SQL2, reschedule both the log shipping copy and the restore jobs so that they occur every minute.
相关考题
-
单项选择题
AfullbackupofyourdatabasenamedDB1iscreatedautomaticallyatmidnighteveryday.DifferentialbackupsofDB1occurtwiceeachdayat10:00andat16:00.Adatabasesnapshotiscreatedeverydayatnoon.AdeveloperreportsthatheaccidentallydroppedthePricelisttableinDB1at12:30.ThelastupdatetoPricelistoccurredoneweekago.YouneedtorecoverthePricelisttable.Youwanttoachievethisgoalbyusingtheminimumamountofadministrativeeffort.Youmustalsominimizetheamountofdatathatislost.Whatshouldyoudo?（）
A. Restore the most recent backup into a new database named DB1bak. Apply the most recent differential backup. Copy the Pricelist table from DB1bak to DB1.
B. Delete all database snapshots except the most recent one. Restore DB1 from the most recent database snapshot.
C. Recover DB1 from the most recent backup. Apply the most recent differential backup.
D. Copy the Pricelist table from the most recent database snapshot into DB1. -
多项选择题
Yourcompanyusesamission-criticaldatabasenamedDB1,whichislocatedonaservernamedSQL1.YouwanttomirrorDB1onasecondservernamedSQL2.Beforeyoucanestablishdatabasemirroring,youneedtoprepareDB1andtheserversformirroring.Whichthreeactionsshouldyouperform?（）
A. Set the recovery model of DB1 on SQL1 to bulk-logged recovery.
B. Set the recovery model of DB1 on SQL1 to full recovery.
C. Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option.
D. Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option.
E. Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.
F. Create endpoints on all participating servers.
G. Set the AutoShrink property of DB1 on SQL1 to false. -
单项选择题
YourcompanyusesaSQLServer2005database.CustomerdatafromyourtradingpartnersisimportedintotheCustomerstableeverynight.YouneedtoensurethatthecustomerrecordisupdatedifitalreadyexistsintheCustomerstable.Iftherecorddoesnotexist,thedataneedstobeinsertedintotheCustomerstable.Whatshouldyoudo?（）
A. Create a FOR trigger.
B. Create an INSTEAD OF trigger.
C. Create an AFTER trigger.
D. Create a DDL trigger.
