首页 资讯 AsupportengineerreportsthatinsertingnewsalestransactionsinaS

AsupportengineerreportsthatinsertingnewsalestransactionsinaS

AsupportengineerreportsthatinsertingnewsalestransactionsinaSQLServer2005databaseresultsinanerror.Youinvestigatetheerror.Youdiscoverthatinoneofthedatabases,adeveloperhasaccidentallydeletedsomedatainatablethatiscriticalfortransactionprocessing.Thedatabaseusesthefullrecoverymodel.Youneedtorestorethetable.Youneedtoachievethisgoalwithoutaffectingtheavailabilityofotherdatainthedatabase.Whatshouldyoudo?()

A.Backupthecurrenttransactionlog.Restorethedatabasewithadifferentnameandstopatthepointjustbeforethedataloss.Copythetablebackintotheoriginaldatabase.

B.Backupthecurrenttransactionlog.Restorethedatabasetothepointjustbeforethedataloss.

C.Restorethedatabasefromtheexistingbackupfilestoatimejustbeforethedataloss.

D.Restorethedatabasetothepointofthelastfullbackup.

参考答案:A

本文来自网络,不代表煤炭资讯立场。转载请注明出处: http://www.mtxh.cn/zx/414303.html
上一篇
下一篇

作者: Anita

为您推荐

返回顶部