40. 在SQL Server 2000中,设已对MyDB数据库进行了如下图所示的备份操作,备份数据均存储在bk设备上,且该设备仅包含这些备份数据。
下列利用bk设备上的数据进行恢复的操作,正确的是______。
A.RESTORE DATABASE MyDB FROM bk WITH FILE= 1, NORECOVERY RESTORE DATABASE MyDB FROM bk WITH FILE = 3, NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE= 4
B.RESTORE DATABASE MyDB FROM bk WITH FILE= 1, NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE = 2, NORECOVERY RESTORE DATABASE MyDB FROM bk WITH FILE = 3, NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE = 4
C.RESTORE DATABASE MyDB FROM bk WITH FILE= 1, NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE = 2 RESTORE DATABASE MyDB FROM bk WITH FILE = 3, NORECOVERY RESTORE LOG MyDB FROM bk WITH FILE = 4
D.RESTORE DATABASE MyDB FROM bk WITH FILE = 1 RESTORE LOG MyDB FROM bk WITH FILE = 2 RESTORE DATABASE MyDB FROM bk WITH FILE = 3 RESTORE LOG MyDB FROM bk WITH FILE = 4