柠檬试题库
search
首页 计算机 公务员 驾照 关于

在SQL Server 2008中,设先对MyDB数据库进行了一次完整备份,然后对该数据库进行了一次日志备份,这两次备份均备份在BK设备上。假设BK设备上只有这两次备份的内容。现要从备份中恢复MyDB数据库,正确的恢复过程及语句是( )


  • A.restore log MyDB from BK with file = 1,norecovery restore database MyDB from BK with file = 2
  • B.restore log MyDB from BK with file = 1,norecovery restore database MyDB from BK with file = 2,norecovery
  • C.restore database MyDB from BK with file = 1,norecovery restore log MyDB from BK with file = 2,norecovery
  • D.restore database MyDB from BK with file = 1,norecovery restore log MyDB from BK with file = 2
热度🔥349
参考答案:D
解析:打开微信小程序查看本题解析