您维护一个SQL SERVER 2008实例，其中包含名为Finance的数据库。Finance数据库的备份策略指定以下要求： 每天08:00执行完整数据库备份，备份到名为finance.bak的文件。 从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;
正确答案是B