在SQL server 2008中,设先对MyDB数据库进行了一次完整备份,然后对该数据库进行了一次日志备份,这两次备份均备份在BK设备上。假设BK设备上只有这两次备份的内容。现要从备份中恢复MyDB数据库,正确的恢复过程及语句是______。
A.
restore log MyDB from BK with file=1,norecoveryrestore database MyDB from BK with file=2
B.
restore log MyDB from BK with file=1,norecoveryrestore database MyDB from BK with file=2,norecovery
C.
restore database MyDB from BK with file=1,norecoveryrestore log MyDB from BK with file=2,norecovery
D.
restore database MyDB from BK with file=1,norecoveryrestore log MyDB from BK with file=2