70-282 Question #358: Real Exam Question with Answer & Explanation

You work as the network administrator at certways.com. The certways.com network consists of a single Active Directory domain named certways.com. A computer named SR02 has Windows Small Business Server 2003 with SQL Server installed. SR02 contains two Disks. On the one disk the SQL database and the other disk the transaction log. Backup have been scheduled on a daily basis at 11:45A .M. for both disks. As per usual a full database backup is completed at 12:00 noon.One Wednesday the following sequence of events occurred: 12:15 P.M. - Transaction 20 starts. 1:20 P.M. - Differential backup begins. 1:21 P.M. - Transaction 21 starts. 1:22 P.M. - Transaction 22 starts. 1:23 P.M. - Transaction 20 commits. 1:30 P.M. - Differential backup completes. 1:35 P.M. - Transaction log backup starts. 1:40 P.M. - Transaction log backup completes. 1:42 P.M. - Transaction 21 commits. A hard disk failure occurs at 1:45 P.M. Consequently you were instructed to replace the failed disk. You want to accomplish the task by recovering the database. Identify the state to which you can recover the database?