您维护一个 SQL SERVER 2008 实例,其中包含名为 Finance 的数据库。 Finance 数据库的备份策略指定以下要求: l 每天 08:00 执行完整数据库备份,备份到名为 finance.bak 的文件。 l 从 08 : 15 开始,每 15 分钟进行一次事务日志备份,备份到名为 finance_HHMM.tm 的文件。 Finance 数据库正在单用户模式下使用。一位用户在 08 : 40 报告, 08 : 23 执行的查询意外删除了一些重要数据。您需要将数据库还原到其原始状态。您应该使用哪条 T_SQL 语句? A. RESTORE DATABASE Finance FROM DISK=’t:\backups\finance.bak’ WITH NORECOVERY; RESTORE LOG Finance FROM ‘t:\backups\finance_0830.trn’ WITH RECOVERY,STOPAT=’Mar 17,2008 08:23 AM’; B. RESTORE DATABASE Finance FROM DISK=’t:\backups\finance.bak’ WITH NORECOVERY; RESTORE LOG Finance FROM ‘t:\backups\finance_0815.trn’ WITH NORECOVERY; RESTORE LOG Finance FROM ‘t:\backups\finance_0830.trn’ WITH RECOVERY,STOPAT=’Mar 17,2008 08:23 AM’; C. RESTORE DATABASE Finance FROM DISK=’t:\backups\finance.bak’ RESTORE LOG Finance FROM ‘t:\backups\finance_0815.trn’ WITH NORECOVERY; RESTORE LOG Finance FROM ‘t:\backups\finance_0830.trn’ WITH RECOVERY,STOPAT=’Mar 17,2008 08:23 AM’; D. RESTORE DATABASE Finance FROM DISK=’t:\backups\finance.bak’ RESTORE LOG Finance FROM ‘t:\backups\finance_0815.trn’ WITH NORECOVERY; RESTORE LOG Finance FROM ‘t:\backups\finance_0830.trn’ WITH RECOVERY;