Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
leonardo_ndo
Starting Member
1 Post |
 Posted - 2012-04-18 : 08:13:01
|
| Hi folks, on the microsoft training kit cd, i have the following question about backuping a SQL Server 2008 database:The backup schedule for the Mineralogical database is as follows: * Full backup: Friday at 01:00, or 1:00 A.M. * Differential backups: Saturday through Thursday at 01:00, or 1:00 A.M. * Transaction log: Every hour on the hour.On Tuesday, the Mineralogical database crashes at 03:25, or 3:25 A.M.Which of the following do you need to do to restore data? (Choose all that apply.)The Correct answers are:Restore Friday backupRestore Tuesday backupRestore 02:00, or 2:00 A.M., transaction logRestore 03:00, or 3:00 A.M., transaction logRestore 04:00, or 4:00 A.M., transaction logI really didn't undestand why i need to restore the 4:00AM transaction log, if the database chashed at 3:25AM. Can someone please explain?Thanks... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-04-18 : 09:41:41
|
Because you want the "tail" of the log file too.The 03:00 log backup only contains log events up to 03:00 and the crash occured 03:25.That's why you need the 04:00 log file too, because it contains all events that happened between 03:00 and 04:00.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
|
|
70-432 Backup Question