单选题
在SQL Server 2000中,设已对MyDB数据库进行了如下图所示的备份操作,备份数据均存储在bk设备上,且该设备仅包含这些备份数据。
A、
RESTORE DATABASE MyDB FROM bk WITH FILE=1,NORECOVERYRESTORE DATABASE MyDB FROM bk WITH FILE=3,NORECOVERYRESTORE LOG MyDB FROM bk WITH FILE=4
B、
RESTORE DATABASE MyDB FROM bk WITH FILE=1,NORECOVERYRESTORE LOG MyDB FROM bk WITH FILE=2,NORECOVERYRESTORE DATABASE MyDB FROM bk WITH FILE=3,NORECOVERYRESTORE LOG MyDB FROM bk WITH FILE=4
C、
RESTORE DATABASE MyDB FROM bk WITH FILE=1,NORECOVERYRESTORE LOG MyDB FROM bk WITH FILE=2RESTORE DATABASE MyDB FROM bk WITH FILE=3,NORECOVERYRESTORE LOG MyDB FROM bk WITH FILE=4
D、
RESTORE DATABASE MyDB FROM bk WITH FILE=1RESTORE LOG MyDB FROM bk WITH FILE=2RESTORE DATABASE MyDB FROM bk WITH FILE=3RESTORE LOG MyDB FROM bk WITH FILE=4
【正确答案】
A
【答案解析】
[解析] 在进行数据恢复时,首先恢复完全备份,其次恢复差异备份,最后恢复日志备份。
提交答案
关闭