PrepAway - Latest Free Exam Questions & Answers

which Transact-SQL statement(s) should you use to achieve this?

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. And the Funds database is being used in single-user mode. The backup strategy for the Finance database meets the following two requirements:
1. At 09:00 every day, full database backup to a file called funds.bak is performed.
2. Since 09:15 every day, a transaction log backup to a file named funds_HHMM.trn is performed every 15 minutes.
A user came to report that a query deleted some important data by accident. The query was executed at 09:24. You are asked to recover the database to its original state. So which Transact-SQL statement(s) should you use to achieve this?

PrepAway - Latest Free Exam Questions & Answers

A.
RESTORE DATABASE Funds FROM DISK = ‘t:\backups\Funds.bak’ WITH NORECOVERY; RESTORE LOG Funds FROM ‘t:\backups\Funds_0930.trn’ WITH RECOVERY, STOPAT = ‘Mar 17, 2008 09:24 AM’;

B.
RESTORE DATABASE Funds FROM DISK = ‘t:\backups\Funds.bak’;RESTORE LOG Funds FROM ‘t:
\backups\Funds_0915.trn’ WITH NORECOVERY;RESTORE LOG Funds from ‘t:\backups \Funds_0930.trn’ WITH RECOVERY;

C.
RESTORE DATABASE Funds FROM DISK = ‘t:\backups\Funds.bak’;RESTORE LOG Funds FROM ‘t:
\backups\Funds_0915.trn’ WITH NORECOVERY;RESTORE LOG Funds From ‘t:\backups \Funds_0930.trn’ WITH RECOVERY, STOPAT = ‘Mar 17, 2008 09:24 AM’;

D.
RESTORE DATABASE Funds FROM DISK = ‘t:\backups\Funds.bak’ WITH NORECOVERY;
RESTORE LOG Funds FROM ‘t:\backups\Funds_0915.trn’ WITH NORECOVERY; RESTORE LOG Funds From ‘t:\backups\Funds_0930.trn’ WITH RECOVERY, STOPAT = ‘Mar 17, 2008 09:24 AM’;


Leave a Reply