AsupportengineerreportsthatinsertingnewsalestransactionsinaSQLServer2005databaseresultsinanerror.Youinvestigatetheerror.Youdiscoverthatinoneofthedatabases,adeveloperhasaccidentallydeletedsomedatainatablethatiscriticalfortransactionprocessing.Thedatabaseusesthefullrecoverymodel.Youneedtorestorethetable.Youneedtoachievethisgoalwithoutaffectingtheavailabilityofotherdatainthedatabase.Whatshouldyoudo?()
A.Backupthecurrenttransactionlog.Restorethedatabasewithadifferentnameandstopatthepointjustbeforethedataloss.Copythetablebackintotheoriginaldatabase.
B.Backupthecurrenttransactionlog.Restorethedatabasetothepointjustbeforethedataloss.
C.Restorethedatabasefromtheexistingbackupfilestoatimejustbeforethedataloss.
D.Restorethedatabasetothepointofthelastfullbackup.
参考答案:A