问题 单项选择题

在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

答案

参考答案:A

解析:

在进行数据恢复时,首先恢复完全备份,其次恢复差异备份,最后恢复日志备份。

问答题 案例分析题
选择题